Skip to Content

How can I have As-Is and To-Be-Values in a calculation view?

Aug 24, 2017 at 01:03 PM


avatar image

Dear all,

I have the following requirement:

In a Design Studio Dashboard, I need to display a column chart combined with a line chart. The InfoChart-Component has the ability to display measures as columns and line as well.

The datasource of the InfoChart is a HANA Calculation View. In this view I have data from workorder confirmation on a time base, that means, data like workcenter, workorders and a date are the attributes.

Now I need to add target values (or setpoints - I'm not sure what the correct english phrase is) to this view. These values represent values like "How much pieces do I have to produce every day on a certain work center". These values are constant within one year but can change over time.

My problem now is: When I join the target value to the records from the workorder confirmation, they get added as soon as I display the values e. g. in a crosstab aggregated for a workcenter (like every other measure). It is not possible for me to tell the calculation view not to aggregate the measure. And defining them as a attribut is also not possible, because attributes can not be used on the values axis in the InfoChart of the DesignStudio.

Does anybody know how to solve such a requirement?

Best regards,
Oliver Reichardt

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers