cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Design Studio 1.4 with SSAS cube

Former Member
0 Kudos

Hi Experts,

Am new to SAP Design Studio . We are on SAP BI 4.1 SP5 and have also installed SAP Design Studio 1.4.

We have created our OLAP cubes using SSAS application and have UNX Universes built on these cubes. Am not able to access the OLAP universes from Design Studio. .Am able to access relational universes from Design Studio (these universes are built by connecting to the Sql Server database directly)

1.How can I connect to the SSAS cube or universes pointing to the SSAS cube from Design Studio

2. Does Design Studio support connecting to a SSAS cube ?

Please let me know your thoughts on this.

Best Regards,

Rakesh Sudhakar

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

Hi - have you checked the official help at http://help.sap.com/businessobject/product_guides/AAD14/en/ds14_user_en.pdf page 67 - is SSAS listed as a supported universe?  If not, then it is not yet supported.

Former Member
0 Kudos

Thanks for the quick reply Tammy :slightly_smiling_face:

Don't see SSAS in the pdf :disappointed_face:

The cube (the universe points to this cube) was built using Microsoft Analysis Services , is there any way to access the cube from Design Studio ? If not what  other tools can I use to access the cube\cube universe so i can distribute this over mobile devices ?

Regards,

Rakesh

TammyPowlas
Active Contributor
0 Kudos

Could you create content on Analysis OLAP and send that to Design Studio (just a guess on my side) and then enable mobile content there?

mike_howles4
Active Contributor
0 Kudos

You'd probably be stuck with a UNX on the relational tables directly, but you've already mentioned that.  Also there's a performance hit of course...

I'd be curious to hear if the path Tammy gave would work (AOLAP -> Export DS App -> See what happens or if you get an error/or if it's disabled for SSAS sources)

TammyPowlas
Active Contributor
0 Kudos

And a slight update - not universe on SSAS -

But Analysis OLAP on SSAS to Design Studio...not sure if that will work.

Former Member
0 Kudos

Tried the Export to Analysis  from AOLAP but the export to  Application button is disabled.

I have all the rights/access (I have Admin access) ..wonder if there is any other way to access the cube

Regards,

Rakesh

Answers (1)

Answers (1)

Former Member
0 Kudos

Looks like Design Studio 1.4 does not support SSAS cube yet ..hopefully they will have an upgrade in future ...

Thanks for all the valuable inputs

Regards,

Rakesh