Skip to Content
0

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

May 17, 2017 at 05:17 AM

222

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mustafa Bensan May 17, 2017 at 05:27 AM
0

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.

Show 6 Share
10 |10000 characters needed characters left characters exceeded

Hi Mustafa Bensan,

Thanks for the response. I'm directly accessing Info cube, not bex query.

Design studio mode: SAP Business Objects BI platform Mode

Hence I'm getting access to the info cube but not bex query. In cube, I'm getting 600,000 rows no I need to limit employees object to 500.

0

Hi Ravi,

What is the reason you are accessing the InfoCube directly instead of using a BEx Query? This is definitely not a recommended approach as it limits the options available to you. For example, you cannot apply Conditions or Variables to restrict the data.

You could try restricting the data by applying the setFilter() method during application startup but this will only allow filtering based on dimension members and not measure values.

Regards,

Mustafa.

0

Hi Mustafa,

Thanks for the response. Sorry late responding as I got another work to look out. Please help me regarding this I'm totally struck.

Below screenshot is the preferences chosen in sap design studio

  • ds1.jpg
  • In my sandbox server, these are the list of info cubes.

  • I selected info cube for one data source. There is no query selection. How can I access the bex query.

Thanks in advance. please help me to sort out the issue.

Regards,

Ravi Bodala

ds1.jpg (69.0 kB)
ds2.jpg (45.9 kB)
ds3.jpg (35.9 kB)
ds1.jpg (69.0 kB)
0

Hi Ravi,

Since you are running in BI Platform Mode, it looks like all of the BW OLAP connections have been configured to point directly to specific InfoCubes. This is why you do not have visibility to any of the associated BEx Queries. You should ask your BusinessObjects BI Platform Systems Administrator to configure an OLAP connection that simply points to the BW System and not specifically to a particular InfoCube. This way, you will see all BEx Queries that you have authorisation for instead of just an explicit InfoCube.

You can recognise that the OLAP connection points to a system rather than an InfoCube based on the icon, as shown in the example below:

Regards,

Mustafa.

1

Thanks Mustafa It's working fine.

1

Hi Ravi - I agree with Mustafa; using the cube as the datasource is not best practice. It would be better and faster for your users if you did this back in the BEx Query and your application - see slide 29 here - Design Studio supports this: https://discuss.asug.com/servlet/JiveServlet/previewBody/47349-102-1-70761/BIA7027_7027_Presentation_1.pdf

0