on 05-08-2006 12:45 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It seems easy, doesn't. You create a MultiProvider which contents C10 AND C08!
Good luck.
My email is: coen.tran@diolen.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.