How do I calculate a new key figure based on a NDT?

moebe
Participant V

The following problem:

In my base I calculate key figures.
For performance reasons and for reasons of key figure correctness I now need a persisted table from a subset of the master data and key figures.
Normally I do this via PDT. But in this case this has the decisive disadvantage that I have to define the key figure in the PDT as well. This means that I always have to remember to adjust the PDT when adjusting the key figure.
Here the NDT would be the better solution.
But unfortunately I cannot manage to calculate another ratio on the persistent NDT.
Actually I would like to do nothing else but:
view: NDT{
derived_table: {
datagroup_trigger: trigger
explore_source: fact{
column: a { field: dim.a}
column: b{ field: dim.b}
column: kf{ field: fact.kf} } } --> definition of the keyfigure in the fact_kf view (its a max)
dimension: a {label:bla type: string}
dimension: b {label:bla type: string}
dimension:kf {label:bla type: number}
measure: sum_kf {label:bla type: sum}

How do I do that?

0 1 152
1 REPLY 1

moebe
Participant V

Simple solution.
Thanks to @brendan_buckley.
I missed to define a primary key on the ndt. Thats the simple reason, why I was not able to add a measore on top of the ndt.

Top Labels in this Space
Top Solution Authors