How to get the flag value

[abc_18]

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?

[tresB]

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

[sunny_talwar]

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"

[tresB]

Absolutely, yes.

[abc_18]

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.

[tresB]

Have you ever loaded the fact table with '0' flag? Like:

0 as "Backorder flag"