Display initial 5k records in the table

[Imbue20]

Hi,

I am having a table with nearly 5M records but since it takes long time to display user asked to show only 5k records initially,  Later on when the user selects any filter like  company code then the records should display accordingly ( even the records are 50k for that selection) . Again when the filter is removed the records should be 5k.

Please help me out to achieve this !!

[vinieme12]

if this table is only being used to download data, then I would just you minimize the entire table

this way the table data will be loaded but the time it takes to render the data will be avoided, the user can just right click on the minimized table and export as usual

[Imbue20]

Okay, but isn't there any way  where I can show initial 5000 records out of all 5M records in the table .?

[vikasmahajan]

Hi,

you can give first command see syntax 

Sales_Fact :
first 5000
LOAD

"Month",
//TransactionDate,
TransactionDate as Trndate,
num(TransactionDate) as AsOfDate,
"MonthName",
MonthYearNum,
month_name,
"year",
quarter_name,
monthstart_date,
monthstart_date_num,
Sales,
Units
FROM [$(vSharedTransformQvds)SALES_FACT.qvd] (qvd);

[BrunPierre]

The first prefix to the load statement will only pull 5000 records into the model. But I believe your requirement is to filter at the front end. If so then, I would do something like this

Script

Data:

Load * ,

RowNo() as reocrdCount

From MainTable;

Expression

Sum(if(reocrdCount <= 5000,YourMeasure)) //aggregation of your measure to display initial 5000 records

[Imbue20]

Thanks Peter, you caught my requirement.

But unfortunately my table doesn't contain even one single measure, all are dimensions.

Then what should be the case .?

( And i need to enter this logic in data handling Right ?)

[BrunPierre]

Provide some sample data.