Skip to Content
author's profile photo Former Member
Former Member

Map local dashboard to BI platform using OLAP connection

Hi,

I created a dashboard in Design Studio locally which includes 3 BW queries as data sources and during importing I mapped it to an OLAP connection (Sales multi cube) that I can save it to the BI platform.

Then I was able to publish it using the BI Launch pad.

The question is:

Should we create an OLAP connection for each query in Central Management Console?

I could map the local dashboard to BI platform using one OLAP multi-cube connection because all these 3 BW queries were on the same multi-cube. What if I use queries based on different cubes?

And if I create a dashboard directly on the BI platform I cannot use a Sales Multi cube as a connection because I cannot see all the queries inside.

How do you map your local dashboards?

Any suggestions, best practices?

Thanks in advance,

Regards,

Deniz

map2.png (27.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 14, 2015 at 12:33 PM

    Hi Deniz - I think this goes more towards your strategy on OLAP connections. I prefer to leave the OLAP connection wide open to the system and let the BW authorizations address access. I recommend trying this with Design Studio. See @Ingo Hilgefort answer here: Best Pratice on OLAP Connections | SCN

    Local dashboards I connect directly to the query.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.