Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am needing to put more than one dimension in a table so that they are below each other instead of next to each other like it normally does so it would look something like this:
Dimensions | Data |
Store 1 | 100 000 |
Store 2 | 150 000 |
Store 3 | 75 000 |
Store 4 | 50 000 |
375 000 | |
Product 1 | 25 000 |
Product 2 | 125 000 |
Product 3 | 150 000 |
Product 4 | 75 000 |
375 000 | |
Region 1 | 225 000 |
Region 2 | 150 000 |
375 000 |
Does anyone have any suggestions of how to achieve this? Using cyclical dimensions and things like that are not going to work as they need the report in this format for a specific reason.
Thanks
Colleen
use same field name for this in your script load.
You have to load a table like this
Store:
LOAD * INLINE [
Store, StoreAmt
Store 1, 100 000
Store 2, 150 000
Store 3, 75 000
Store 4, 50 000
];
Product:
load * Inline
[
Product , ProdAmt
Product 1, 25 000
Product 2, 125 000
Product 3, 150 000
Product 4, 75 000
];
Region:
LOAD * Inline
[
Region,RegionAmt
Region 1, 225 000
Region 2, 150 000
];
Final:
LOAD
Store as Dimensions,
StoreAmt as Data
Resident Store;
Concatenate
LOAD
Product as Dimensions,
ProdAmt as Data
Resident Product;
Concatenate
LOAD
Region as Dimensions,
RegionAmt as Data
Resident Region;