Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my report,dashboard I need to distinguish the data as 'All order' and 'Backorder'
In the fact table I have added one line
1 as 'Backorder flag'
now I need to create a inline table so that user can select the data from drop-down
load * inline
%source source
0 All orders
1 Backorder
how to link fact table and inline table in this case?
May be you just have to create the inline load like this?
load * inline [
"Backorder flag" source
0 All orders
1 Backorder
]
And a small correction in fact table like:
1 as "Backorder flag" // double quotes instead of single
Edit: corrected
Shouldn't it be this
load * inline [
"Backorder flag", source
0 All orders
1 Backorder
];
or change the other side like this
'Backorder' as "Backorder flag"
Absolutely, yes.
Hi Tresesco,
Thanks for your response.
I did the same, but in front end while selecting values from drop-down box, '1' is appearing as default value and another one is 'undefined' similar as no data.
But I need to show All orders vs Backorders data.
Have you ever loaded the fact table with '0' flag? Like:
0 as "Backorder flag"