on 01-28-2016 8:05 AM
Hi,
Does anyone know whether Index Awareness works for Aggregate Aware dimension object in IDT tool.
I'm using Teradata as a database where there is concept of Primary Index and not Primary key or foreign key. However it works for non aggregate aware objects.
Current BO Version: BI 4.1 SP5 P7
Thanks for your help in advance.
Hi Mantu,
When we define an Aggregate aware object, we define it as follows:
=@Aggregate_Aware(<highestlevel_column>,<lowerlevel_column>,.....,<lowestlevel_column>)
the higher levels come from the summary tables. Do you have indexing in them? If yes, are all objects used in above definition index aware?
Hope it will help you in taking the primary steps towards fixing the issue.
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
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.