cancel
Showing results for 
Search instead for 
Did you mean: 

Index Awareness on Aggregate Aware objects

former_member190895
Active Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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