Role filter on a query
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