How to link dimension to another dimension

[plkkw]

I found that there are dimension:
date: Year/ quarter/ month / date
product: Product line / Product Category / "Product subcat + product"/ product
product subcat: product subcat

For product subcat, the element are MEN, WOMEN, BABY
For product dimension, product should be A0001, A0002, B0001, and the 3rd level ("Product subcat + product") should be: "MEN - A0001", "MEN - A0002", "BABY - A0003". "MEN - B0001"

And there is a cube: cubeQty using year, product only (without product subcat).

But in a websheet (or excel), I found that there are dropdown boxes:
product category (e.g. prodcat A. prodcat B),
product subcat: MEN, WOMEN, BABY
And there are tablet report using product as first column; second colum is qty (not a key point for this issue)

I am surprised thatd the dropdown box: product subcat can be used to filter "product" in cubeQty because there is no direct relationship between product subcat and cubeQty.

My question is: How to use dimension product cat linked with dimension: product, and then filter the cubeQty for generating a websheet report?

[Martin Ryan]

And there is a cube: cubeQty using year, product only (without product subcat).

My question is: How to use dimension product cat linked with dimension: product, and then filter the cubeQty for generating a websheet report?

You can't, because of the first quote. The product subcat is not in the cube, therefore you can't slice the cube by that dimension. Just like you can't slice it by customer, because there's no customer dimension.

You'll either have to rebuild the cube to include the dimension, or use drill through to go back to the source system where the extra level of detail is available.

Martin

[plkkw]

HI Martin,

How to do drill-through in an Excel? How do I want the existing websheet (or Excel) using drill-through?

[Martin Ryan]

Drill through is explained in the documentation.

Martin

[plkkw]

Hi,

I have right click relevant cubes -> drill -> edit drill-through rule, but I find nothing in the editor. However do I verify that the existing cube used drill-through feature?

[Martin Ryan]

You need to setup the drill through. It is not automatic.

See the documentation for more details.

Martin