Hi All,
I have a requirement where in a dimension Dim1 has 4 possible values ( a,b,c,d ). Two cubes are being created from my mdl file.
a) Non-Admin cube Should show only a,b for Dim1
b) Admin cube should show all values (a,b,c,d) for Dim1
Dimension source is a column from fact table.
Current approach followed is : I have created 2 separate dimensions under Dimension map(AdminDim1 and Non-AdminDim1) and 2 cubes (Admin and Non Admin)
in non-admin version of the Dimension : I have used "Exclude" in the categories window to exclude "c" and "d" categories.
In Admin cube I have Omitted the Non-Admin version of the dimension and vice versa for Non-admin.
Problem here is "Exclude" seems to exclude the categories from both the Cubes. Please suggest an alternative or work around for the same approach.
I think you will want to use custom views. The following section of the user guide explains it pretty well, I think, and is rather similar to your situation.
http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cogtr.10.2.1.doc/t_adddimview.html%23AddDimView (http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cogtr.10.2.1.doc/t_adddimview.html%23AddDimView)
Thanks a lot !! That really helped :)