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

Aggregates and navigational attributes

I'm trying to create an aggregate for a query that displays cost element, cost center, and business area (which is a nav. attribute of cost center). I know that you shouldn't create an aggregate containing both a characteristic and a nav. attribute of that characteristic.

Which aggregates should be created for this query? If I create one aggregate with cost element and cost center, would business area automatically be covered? Or would I need one aggregate with cost element and cost center, and a second aggregate with cost element and business area?

I would have BW propose an aggregate for this query, but it's based off a multiprovider.

Thanks,

Jason

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 02:57 PM

    Hello Jason,

    you need a Aggreagte for cost element, cost center.#

    If I create one aggregate with cost element and cost center, would business area automatically be covered? --> yes

    Kind regards

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 03:00 PM

    Why not create an aggregate with cost center, cost element and business area? Let the BW do the aggregate handling, it should be fine.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There are two similar queries I'm working with: one built off a multiprovider (0cca_c11 and 0ps_c04), and one built off only 0ps_c04. For the multiprovider query, I get a GETWA_NOT_ASSIGNED short dump (You attempted to access an unassigned field symbol - data segment 45) after the display aggregates found screen.

      For the 0ps_c04 query, I get QDBSEL: 10455, QDBTRANS 4161. This is using an aggregate with a mean value of 10.

      If I could see the full text of the "Not Possible Because" column in the Select Aggregates screen, that would help me determine why the report is not using aggregates with higher valuation.

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.