dashboard with hierarchy selector with webi as a source

[jan_balek]

Hello,

we want to create dashboard with hierarchy selector. Data comes from Webi with Bex connection.

In Webi I see hierarchy without any problems, and I want to use this hierarchy in dashboard.  What is the best way to create dashboard with hierarchy selector on top of webi data?

big thanks

[jan_balek · Accepted solution]

Hi Sapanesh,

I already tried new direct connection in FP03 from dashboard to query,in query browser when i select BEX, , it is showing only the CMS name(nothing else). also "next" button is disabled.

I already created OLAP connection in IDT, but still empty query browser in Dasboard designer. Please advise where sould be problem?

thanks

[sapanesh_agnihotri · Accepted solution]

HI Jan,

Please try creating the Olap connection from CMC with authentication as predefine.

also bex query should be available  for external access(BW people can help here).

Thanks,
Sapanesh

[sapanesh_agnihotri · Accepted solution]

Also some time we are only select the cubes in panel not the query which in inside.

[jan_balek · Accepted solution]

Hi Sapanesh,

I have external access in query and I already tried connection from CMC,but still it is showing only BOE server name,no queries,no cubes.

I Didn’t find any OSS notes about minimal BW level.

thanks

[sapanesh_agnihotri · Accepted solution]

Hi Jan,

Are the same Olap connection is visible in webi rich client for Bex connection?

if this is visible then should be available for dashboard even.

and the authentication type should be predefine in CMC Olap Connection its mandatory.

Thanks,
Sapanesh

[jan_balek · Accepted solution]

Hi Sapanesh,

OLAP connection works in webi web BO 4.0 client, but still not in dashboard query browser, i dont know if webi and dashboard using same type of connection?

Which patch of FP03, do you have?

thanks

[sapanesh_agnihotri · Accepted solution]

Using FP3 only