How to exclude "division_key" from expression

[suvechha_b]

Hi,

How can I exclude the "division_key" from the inbound expression:

"sum({<[division_key]=>}ordered_quantity)"

But we can see from the below screenshot that in the "inbounds" , "blockedstock" are not linked with "division_key","SEP".

How to solve this problem.

Sample attached.

[sunny_talwar]

Not sure I understand your concern, would you be able to elaborate and point in your document what is the concern?

[suvechha_b]

The report is having "Division".

But my Inbound Orders is not linked with "Division" thus it is showing null. How can I write the expression so that the

expression of "Inbound" doesn't depend on "Division".

[ThornOfCrowns]

I would first suggest you have a look at the data to try to eliminate the multiple synthetic keys you have in that schema.

[sunny_talwar]

So you are trying to get rid of 9143 number? May be use 'Suppress When Value is Null' for the Division dimension?

[suvechha_b]

But I need the Model depends on [Trans Date]

means every day records to be stored.

[suvechha_b]

Sorry, you didnt understand me. I doesn't want to get rid for the value "9143".

My datawarehouse is having the following data :

You can see that my datawahouse is not having division. But I need the "Division" in my report.

and I need the data as,

everyday,

[Trans Date] [Value]

20160401    100

20160402     200

...

20160525  500.

[ThornOfCrowns]

I'm not saying drop the data, I'm saying you should look at why you've so many synthetic keys in your schema.