OLAP Cube reports to Exploration Information spaces
We want to migrate all the OLAP cube reports to BO explorer Information spaces.
OLAP cubes are of MS BI .
Please let me know if transition is smooth
and what all things need to be taken care of .
Gaurav Mang replied
Thanks Henry Banks
Thanks Merlijn Ekkel.
Legacy system or earlier we are having MS BI Cubes.
Now we want to replace those.
So we were having reports built on top of MS BI Cube.
Now that we have brought RDBMS database i.e Teradata database (So complete different from)
So Data sourcing and other ETL will be done there using Cascade (is for sourcing )
we have informatica and procedures too.
Then there is semantic layer (views created at database)
So the Universe is built on top of these views semantic layer.
So and then we are bringing Exploerer for those OLAP cube reports .
So the MS BI Cubes and other things there are been replaced by RDBMS Teradata database.
Universe is built and that too UNX (using IDT)
So I have to take care few filters and few calculatiosn at cube level into information space or Universe .
Also we are also checking the performance to bring all the corresponding objects which were in that Cube (mapped with Universe objects ) into information space .
So that user is given that particular cube (earlier which he was using ) now in explorer with even graphs and other things included.
I will check the sizing and other links which has been sent
Thank you again .
Thanks and regards