I have a table "Test".
In the Test table, there are different columns, "TestTypeCategory", "IndividualTest1", "IndividualTest2" and so on...
For each "TesttypeCategory" there are values for "IndividualTest1", "Test2" and so on.
I have created a dimension "TestTypeCategory".
I want to create a new dimension "AllIndividualTests" made up of "IndividualTest1" , "IndividualTest2" etc at the same level or hierarchy.
For example if i click on "TestTypeCategory" dimension, I should be able to view "AllIndividualTests" dimension having values "IndividualTest1" , "IndividualTest2" etc..
So basically I want to create a dimension having lets say 5 subdimensions at same hierarchy and each of the subdimension is a column in the Test Table.
Please help !!
Thank you,
In the Test table, there are different columns, "TestTypeCategory", "IndividualTest1", "IndividualTest2" and so on...
For each "TesttypeCategory" there are values for "IndividualTest1", "Test2" and so on.
I have created a dimension "TestTypeCategory".
I want to create a new dimension "AllIndividualTests" made up of "IndividualTest1" , "IndividualTest2" etc at the same level or hierarchy.
For example if i click on "TestTypeCategory" dimension, I should be able to view "AllIndividualTests" dimension having values "IndividualTest1" , "IndividualTest2" etc..
So basically I want to create a dimension having lets say 5 subdimensions at same hierarchy and each of the subdimension is a column in the Test Table.
Please help !!
Thank you,