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

QAAWS Issue

Hi

We are facing an issue with the aggregation of data in QAAWS. The Xcelsius dashboard is built using QAAWS and everything was fine till we introduced a filter in QAAWS.

As per the requirement we needed a Project type(display attribute of Project) filter in the QAAWS, when that is implemented the data started deaggregating

Before O/P

Fiscal Year Amount

001/2011 20

002/2011 50

Current O/P (With filter)

Fiscal Year Amount

001/2011 5

001/2011 10

001/2011 5

002/2011 20

002/2011 30

We tried different options of aggregating the data at the universe level for the measure using Sum function instead of data base delegated -


no luck

-Tried to use Sum(Measure) in the Select -


didn't allow to use as the universe is based on Bex query

Waiting for any other suggestions/options available. Please do the needful.

Regards

PP

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2011 at 06:17 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2011 at 05:23 AM

    Hi

    I got the same problem.So, what I did is I used BI services and created a webservice.Try using BI service.Hope this helps you.Let me know whether this worked for you or not.

    Regards,

    Peri

    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.