Data Load

[Nikhil2725]

Hi,

I have a Straight table which includes dimensions and measures.

It has around 350 dimensions and measures with 2500+ rows.

I want to limit it for 500 rows only for the load to layout with possibility to extract ALL the data (2500+ rows) to excel file.

How do I do it?

Thanks.

[Channa]

try use rownum()

[Nikhil2725]

Hi Channa,
Can u please explain in brief...
If I use Rownum() can i restrict the data to load only 500 rows and while exporting the data can I able to export all the 2500+ rows in the excel file?

[jonathandienst]

>>I want to limit it for 500 rows only for the load

If you limit the load, then you will only be able to export what you loaded. A full export will require a full set of data. You can use dimension limits to display only the first 500. 

But it depends on what should be exported. If the export can be a CSV file, and all the data (dimensions and measures) are in single file, then you can export during the load using STORE. After the store  statement ,  you could do a reload of the resident table with a filter or a FIRST prefix to return only 500 rows and drop the full table.