Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 22, 2006 at 02:15 PM

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

    Good luck.

    My email is: coen.tran@diolen.com

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2006 at 02:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded