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

query problem, group by key figure

Hi,

I have to build a report and need some help.

I have a cube with this data:

receipt | sales | card | counter

51 | 10 | 1001 | 1

52 | 30 | 1002 | 1

53 | 15 | 1003 | 1

54 | 20 | 1001 | 1

This is the report that I need:

We want to see how often our customers used their customer cards.

number of purchases | number of cards | sum of sales

The result of the sample data should be:

1 | 2 | 45 (cards 1002+1003)

2 | 1 | 30 (card 1001)

My problem is how to group by the number of purchases because it is not a characteristic but a key figure.

Any ideas?

Thanks,

Timo

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 14, 2005 at 11:38 AM

    Did you considered the option to define a Tech Characteristic (NUMC??) to be evaluated via ABAP in Update Rules with the same value of the corresponding KF?

    Be carefull with the Dimension Design because the number of occurrecies colud be very high ... and also with the data conversions

    Hope it helps

    GFV

    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.