Create link between dimension

[emma]

Hi.. I'm new in here... i want to ask how to give link to dimension
example
i have 4 dimension in 1 cube
-father
-mother
-son
-daughter
how i recognize which one son's father ,son's mother and son's daughter without create them in 1 dimension
Thank you

[Alan Kirk]

Hi.. I'm new in here... i want to ask how to give link to dimension
example
i have 4 dimension in 1 cube
-father
-mother
-son
-daughter
how i recognize which one son's father ,son's mother and son's daughter without create them in 1 dimension

That does not explain why you would not want to create them in one dimension. In fact creating them as one or more hierarchies in a single dimension is exactly what you would do.

I do however suggest reading the Request For Assistance Guidelines. Hypothetical "Let's say I have a cube named A with dimensions B, C D and E" type questions are not wildly popular. You will get far better answers by explaining exactly what the real data storage problem you are trying to address is. A cube with the dimensions listed above makes no sense from a data analysis perspective.

[emma]

Hi.. I'm new in here... i want to ask how to give link to dimension
example
i have 4 dimension in 1 cube
-father
-mother
-son
-daughter
how i recognize which one son's father ,son's mother and son's daughter without create them in 1 dimension

That does not explain why you would not want to create them in one dimension. In fact creating them as one or more hierarchies in a single dimension is exactly what you would do.

I do however suggest reading the Request For Assistance Guidelines. Hypothetical "Let's say I have a cube named A with dimensions B, C D and E" type questions are not wildly popular. You will get far better answers by explaining exactly what the real data storage problem you are trying to address is. A cube with the dimensions listed above makes no sense from a data analysis perspective.

okay... let me explain... i have cube that will report financial report in all store in all branch in 1 company let's say it "financial report" and the goal is every branch will get user login to check their financial report and can check financial report in regency,subdistrict,village,store ,
the structure of the cube is
-branch
-regency
-Subdistrict
-village
-store
how can i recognize which store that registered in that branch,regency,Subdistrict,village? i already try to create user for branch and set security access for all dimension to branch but the result all regency get the same subdistrict and village,and store....the reason why i didn't want to make them in 1 dimension is... that element will dynamic in every month... the store can move ,or be deleted

thank you

[Alan Kirk]

okay... let me explain... i have cube that will report financial report in all store in all branch in 1 company let's say it "financial report" and the goal is every branch will get user login to check their financial report and can check financial report in regency,subdistrict,village,store ,
the structure of the cube is
-branch
-regency
-Subdistrict
-village
-store

That seems unlikely. You have have specified no dimension for time, you have specified no dimension for measures (sales, profit, expenses, etc).

how can i recognize which store that registered in that branch,regency,Subdistrict,village? i already try to create user for branch and set security access for all dimension to branch but the result all regency get the same subdistrict and village,and store....the reason why i didn't want to make them in 1 dimension is... that element will dynamic in every month... the store can move ,or be deleted

I'm afraid that this doesn't make a lot of sense. Are you saying that for a given period (that is, ignoring the fact that the stores can move over time), a single value (profit, sales, whatever) will relate to:
- A single store;
- In a single village;
- In a single sub-district;
- In a single regency;
- In a single branch?

Because if so, all you need to do is put element level security on the Branch dimension. Zero suppression will take care of the rest. In a zero suppressed view a user will see only the combinations which have non-zero values. They may be able to see all of the village, sub-district, etc elements in the dimension, but the only elements that will be shown in the view are those which have values relating to the branch(es) that they have access to.

[Steve Rowe]

....the reason why i didn't want to make them in 1 dimension is... that element will dynamic in every month... the store can move ,or be deleted

I think that by deciding to solve this problem by putting the components of a dimension into 4 different dimensions you are probably going to create a series of much harder problems for your self.

I would probably create the proper dimension anyway, this will give you an object to query using elpar / elcomp etc from your broken out structure.

You'll need to rely on zero suppression to display the information or perhaps get smart with MDX and active forms.

I'd really strongly advise you to look at what problems the changing structure would cause and see if you can think of other ways to solve them.

Cheers,