Skip to Content
author's profile photo Former Member
Former Member

Query on Aggregates

Dear Experts,

I have build aggregates on characteristics (vendor,company code,business area) of FIAP cube. In bex query i have placed company code and business area in rows and another few characteristics on free characteristics. When i execute report which on top of cube, my query not recolonizing aggregates which i have build, this i have verified in under usage tab of aggregate maintenance.

I have executed report in RSRT and Analyzer

Could please let me know what would be the reason for this..

Capture.GIF (130.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 30, 2014 at 10:07 AM

    Hi,

    What an aggregate 😊 Wonderful valuation.

    Simple things first :

    You have to be sure that all characteristict you use in query are in the aggregate.

    Have you activated your aggregate after transporting the changes to prd.

    Regards,

    Leszek

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2014 at 12:34 PM

    Hi Praveen,

    I see that in your query you have company code and business area together (I think you don't have vendor right?). So if you want the query to run from aggregate, you need an aggregate where company code and business area are both included in the aggregate. Just create a new aggregate including these two characteristics. (when you add free characteristics, then the query will get the new results from the infocube).

    Regards

    Yasemin...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.