on 01-14-2015 5:45 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the quick reply Tammy ![]()
Don't see SSAS in the pdf ![]()
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
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.