How to get values using mapping table

[abc_18]

Hi,

In my dashboard report, I need to show the drop down where user should be able to select:

1.> Massorder &

2.> All orders(should include 'Massorder' + 'Other orders')

I have created a mapping table for that and it's connected to fact table like below

[MAP_IsMassorder]:

Mapping LOAD

skey_line,

'Massorder' as [%order_type]

FROM [order.qvd](qvd);

Fact:

applymap('MAP_IsMassorder',skey_line,'All orders') as %Ordertype

But in drop down, when I select 'All orders' it's not including Massorder values, only Other orders are appearing.

[sunny_talwar · Accepted solution]

I would try like this

LinkTable:

LOAD skey_line,

     'Massorder' as [%order_type]

FROM [order.qvd](qvd);

Concatenate (LinkTable)

LOAD skey_line,

     'All orders' as [%order_type]

FROM Fact;

Fact:

LOAD *

FROM Fact;

[big_dreams]

How we will get to know if order is mass order or other order .

required sample data to understand it.

Sunny logic work but here, there massorder and AllOrders are same, So I think we required where condition to flag it properly.

Regards,

[sunny_talwar]

That is not true if AllOrders and MassOrders are coming from two different qvd files...

[big_dreams]

Sorry my bad. I did not notice that you used different qvd name,

but it is not mention in original question.

Regards,

max

[sunny_talwar]

That's right, but since there is no point of mapping from same qvd to the same qvd... I think there might be one qvd used for mapping and the other one for fact

[big_dreams]

true...

[abc_18]

Thank you very much sunny for your help.

logic is working perfectly.