Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
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,
That is not true if AllOrders and MassOrders are coming from two different qvd files...
Sorry my bad. I did not notice that you used different qvd name,
but it is not mention in original question.
Regards,
max
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
true...
Thank you very much sunny for your help.
logic is working perfectly.