Hi,
I am new to using Powerplay Transformer. I need to create a dimension and I am unsure what's the best practice.
My source data (see below) has a book code (ISBN), Title, Source Country as available data columns. Both the Title and Source Country column is tied to the unique ISBN .
Eg:
[ISBN]Ã, Ã, Ã, Ã, [Title]Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, [Source Country]
1Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, JokesÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, China
2Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, SailingÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, US
3Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, DivingÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Australia
I created a dimension as "ISBN" with "Title" and "Source Country" as its levels and I think it is incorrect, as I have no need of drilling down to the Title and Source Country.
My main question will be how do I create a dimension so that when I look at Powerplay, the crosstab table's format will look like below (with the measure being from another data source) with all the measures displayed as columns (measure is tied only to ISBN).
[ISBN]Ã, Ã, Ã, Ã, [Title]Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, [Source Country]Ã, Ã, Ã, Ã, Ã, Ã, Ã, [Price]
1Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, JokesÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, ChinaÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, $5
2Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, SailingÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, USÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, $11
3Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, DivingÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, AustraliaÃ, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, Ã, $4
Hope this makes sense.
Thank you.
Create your dimension the way around.
Country
Title
ISBN
Mark the ISBN level as UNIQU in transformer.
Create your cube.
Open your cube.
Put ISBN dimension in row and Measures in Column.
Then Right click in row and select Nest , do that 2 times ( Hide subtotals)
Your report will look like
[Source Country] [Title] [ISBN] [Price]
China Jokes 1 $5
US Sailing 2 $11
Australia Diving 3 $4
Lowest levels in dimension have to be uniqu, then measures are aggregated in upper levels.