Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I tried searching for sample scripts but found none. Is there a way to show only the selected/specific rows that contain some values. So basically, I have an app which has over 20 million rows and another app that does the binary load. I don't want to show the entire rows on my sheet because data is huge, I only have to look for 2-10 IDs from that 20 million rows. How do I achieve this?
A binary load fetched always the entire data-model with all data and couldn't be customized in any way. But you could remove the unwanted data afterwards, for example with a noconcatenate resident-load of your fact-table with an appropriate where-clause and then deleting the origin table or maybe filtering the data with an inner join load.
An alternatively might be to apply a section access which could remove the unwanted records during the opening of the application.
Both methods will have their costs - so you may also considering not to apply a binary load else loading the wanted data from qvd's.
- Marcus
You have 2 very easy Options
1) Inner Join(TableName)
2) Inner Keep(TableName)