cancel
Showing results for 
Search instead for 
Did you mean: 

Role filter on a query

Former Member
0 Kudos

I am building a query which is based on the BW Statistics MultiCube (0BWTC_C10). The Multicube currently consists of the following cubes:

BW Statistics - OLAP (0BWTC_C02)

BW Statistics - OLAP, Detail Navigation (0BWTC_C03)

BW Statistics - Aggregates (0BWTC_C04)

BW Statistics - WHM (0BWTC_C05)

BW Data Slice (0BWTC_C06)

Requests in the InfoCube (0BWTC_C07)

BW Statistics: Condensing InfoCubes (0BWTC_C09)

BW Statistics: Deleting Data from InfoCubes (0BWTC_C11)

I have asked to create a query in which the results for a specific role are only displayed. I have looked and found the object 0TCTROLE which is part of the InfoCube 0BWTC_C08 which is not part of the multi-cube. Is the only way that I can filter by the role to include this cube and than use the role object to filter or is there a solution otherwise? Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Niten,

A query can be in multiple roles so how will it be reported on?

This is a very difficult requirement. Query can be in a role, it can be in a role in a web template through a view or directly.

If these complexities are not involved, then I suggest adding 0TCTROLE to the InfoCube and populating the role during the update. I thin that AGR* tables have the quries in a role.

Aneesh

Former Member
0 Kudos

It seems easy, doesn't. You create a MultiProvider which contents C10 AND C08!

Good luck.

My email is: coen.tran@diolen.com