on 10-30-2015 2:04 PM
Dear Experts,
I am Using Navigational Attributes Brand and Category in Query Designer. When I execute My query By placing Brand and Category in Rows. It was Running for more time and at the end it was showing time limit exceeded. If I Place Infoobjects Sold-to-party and division my query is fast.
When I place Navigational Attributes the report is taking long time. Kindly help me on this.
Regards,
Naveen
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Karthick & Hitesh,
Thanks for your inputs. I have added Brand and Category in Infocube Dimensions, And Loading data by Read master data in Transformation. Now The query performance is good.
Regards,
Naveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naveen
It is always recommended to use characteristics rather than navigational attribute to improve the query performance. But in situations, we need navigational attribute like yours
You could increase the query performance by doing creating aggregates which might be helpful.
The aggregates should be created based on the navigational attributes and rollup should be done immediately once the data is loaded. Make sure the aggregates are effective and you could even change if it doesnt have more number of hits. Having an aggregate with no much hits is of no use. So build your aggregates in a useful manner.
Hope this helps
Regards
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.