Hi, i need a help to handle with an oracle cube created by the oracle function group by CUBE. I must design an universe in Bo that allow me make queries on tath table, but i don’t find a smart way to do it. Anyone has ever passed on this problem?
flavio20002 (BOB member since 2010-03-23)
Welcome to B:bob:B!
You can create a derived table where you use the syntax with GROUP BY CUBE.
Marek Chladny 
(BOB member since 2003-11-27)
But how the user can choose wich dimension must be used in the query if it’s all in a derived table?
flavio20002 (BOB member since 2010-03-23)
Hi,
Maybe if you described the whole problem then someone could help.
By the way, GROUP BY CUBE is nothing that BO can generate/work with. That’s way I suggested a derived table because you can put any valid SQL into it. But if you need something more than a “static” derived table then you would either need another solution or a completely different approach to solve the original problem.
Marek Chladny (BOB member since 2003-11-27)
I’m not sure a derived table can help you in this instance, however Oracle does provide an answer.
Oracle automatically creates a view for each cube and dimension.
Whilst the view remains relational, in the background the oracle engine still takes advantage of the multidimensional features of cube_table.
In saying that, it would be an interesting looking universe by the end of the exercise if you have a lot of them.
The Emu 
(BOB member since 2002-09-13)
We’ve done this against several Oracle Cubes. While a bit dated, absolutely nothing has changed with the implementation of this scenario that is fully described at the following link:
(The solution is rather elegant, I might add)
Good luck
Atul Chowdhury (BOB member since 2003-07-07)