I found that there are dimension:
Version: DRAFT, WORKING, FINAL
PLine (1 level only), e.g. L01, L02
PCategory (1 level only), e.g. C01, C02, C03, C04
PSubcat (1 level only), e.g. MEN, WOMEN, BABY
Product (4 level with hierarchy showing below. PLine level, PCategory level, PCategory + PSubcat level, and Product leaf level), e.g
L01 / CO1 / CO1 + MEN / P001
L01 / C02 / C02 + WOMEN / P002
L02 / C03 / C03 + MEN / P003
L02 / C04 / C04 + BABY / P004
Month, e.g. Jan-2010, Dec-2011
"Measure - Product", There are attribute: PLine, PCategory, PSubcat, are Expiry Date (number format for a date), retail price, qty. The value of attribue PLine, PCategory, PSubcat are same as element of dimension: PLine, PCategory, PSubcat respectively.
And there is a cube: Salescube using Version, Product, "Measure - Product"
And there is a websheet (or excel), I found that there are PCategory (e.g. C01,C02) PSubcat (e.g. MEN, WOMEN, BABY), Month (e.g. Jan-2010, Feb-2010) for user to filtering.
I am surprised that PCategory, PSubcat, Month does NOT exist in Salescube. For example, user can select MEN in PSubcat, and then click a rebuild worksheet button, it will extract Product: P001 and P003; select Dec-2010 in Month, it can extract product with expiry date starting from 01-Dec-2010 to 31-Dec-2010.
How can it be used for filtering (not a simple slice and dice feature.)?
Any relationship between dimension: Product and PSubcat can be set? or any dimensions, or cubes can be used as the linkage/relationship?
Filter with dimension not exist in a cube
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: Filter with dimension not exist in a cube
Sorry, but most of your statements/questions I either don't really understand or am not sure whether they are a question or a statement.
To me your post basically reads:
I have lots of dimensions in a model, that I have not created, but some are not used in a cube where I would expect them to be used. Tell me why.
Somehow this cube is used in a Websheet but I don't understand how the report works. Tell me how it works.
The rest is, again sorry, so cryptic...
Here some guesses on your (hopefully) questions in order.
Surprised as well, MDX, yes, yes, yes.
To me your post basically reads:
I have lots of dimensions in a model, that I have not created, but some are not used in a cube where I would expect them to be used. Tell me why.
Somehow this cube is used in a Websheet but I don't understand how the report works. Tell me how it works.
The rest is, again sorry, so cryptic...
Here some guesses on your (hopefully) questions in order.
Surprised as well, MDX, yes, yes, yes.