cancel
Showing results for 
Search instead for 
Did you mean: 

Info-set Execution

Former Member
0 Kudos

Dear All,

I have created one Infoset with two CUBEs and Three DSOs.

and in production environment I have big Data in the report (query Designer), and when I run the report it keeps processing and gets timeout at the end.

how can I optimize or enhance the Infoset run time?

Regards,

Mohammed Alramadan

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Mohammed,

There is not much optimisation options for infosets, but i suppose u can help performance by :

-> For cubes : Optimize the structure and the dimensions.

-> For DSO : - Keep the ID generation when DSO activation, this will slow load data time but it would help for reporting.

- Try to do an sql trace when u execute the query and determine where u do most of database access so u can create indexes on dso.

I had the same problem but i couldn't find a real solution. Applying the options i described allowed to gain little performance time but the query was not productive for large data.

Regards

Raed

Former Member
0 Kudos

Hi,

As you said you have DSOs and Cubes in Infoset.

I would suggest you may create a multiprovder on DSOs and cubes unless Infoset is the must as per your requirement.

As with huge data set infosets are slow in BW.

Check if you can put some of the static filters in query or try to put various dynamic filters.

In Infoset only slect those fileds which are mandatory for report display. It willl save time.

There are not much option to optimize Info Set performance so query otimization or having a multiprovider will help in such case.

I hope it helps.

Thanks,

S