what is the syntax for aggregate awareness?

Answer Posted / suresh

@AGGRIGATE_AWARE(SUMMERY TABLE1.COLUMN,SUMMERY TABLE2.COLUM.........,DETAILED TABLE.COLUMN)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

623


Explain what is aggregate table and aggregate fact table ... Any examples of both?

607


What is object stores?

583


8. How much supervision have you typically received in your previous job?

1834


What is the difference between user and versatile user?

581






Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

602


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2603


What is difference between custom hierarchy and report based hierarchy?

549


How to open a universe with out using the Designer ??

6613


How would you format some text using css to be verdana and bold?

671


Explain when to use local filter and when to use global filter?

607


Explain the difference between union and group?

628


Explain is there any default username & pwd for bo designer & supervisor?

593


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

552


Explain in detail about type 1?

655