Universe based on a SQL Cube

[former_member210662]

Hi Experts

I'm pretty new in the BO metodology and for this reason I'm not sure if what I need it is really possible or not to have.

Today I have a solution based on a SQL Cube that has been created based on several tables in a different data base (also SQL), however the modeling in this cube is what I need to export to a WebInt reports and from my point of view it will be easier if I can use it in my Universe.

So my questions is, can I create a Universe based on this cube ?

Any help will be welcome.

Thx

[Former Member · Accepted solution]

Hi,

You can build universes based on MSAS 2000, 2005 or 2008.

Once you create a connection on a cube the universe is automatically generated and ready to use.

Regards,

Didier

[former_member210662 · Accepted solution]

Would you know if I can use it to create Web Int. reports on it? or only Dashboards?

[gowdatimma_ramu · Accepted solution]

Hi,

Once the Universe is created you can use ot for reporting with Webi based on this Universe.

And for dashboarding there are two options.

MS Analysis Cube -> Universe -> Webi -> Live Office -> Xcelsius Dashboard Designer

MS Analysis Cube -> Universe -> Query as a Web Service -> Xcelsius Dashboard Designer

Regards,

Ramu.

[Former Member · Accepted solution]

Yes, you can do that.

WebI reports you can use for Dashboards, those are within Infoview Dashboards or to Xcelsius. Which is listed out in previous post.

Thank You!!