on 07-12-2010 8:20 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.