Skip to Content
avatar image
Former Member

How to limit / restrict design studio data source back end BI Cube

I'm new to design studio I'm fetching data from info cube. where the cube is fetching more than 600,000 rows, I need to limit the fetching rows.

example: I need to display top 600 employees with salary but data source is fetching entire data and displaying 600,000.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 17, 2017 at 05:27 AM

    Hi Ravi,

    To restrict the result set returned by the data source you should apply filters or variable prompts in your application. If your data source is a BW BEx Query you can define a Top N / Bottom N ranking condition.

    What type of data source are you using?

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded