MDX member formula that always returns a value regardless of attribute?
For simplicity let's say I have a member formula on an account: acct1 = (acct2 / ([acct3],[No dept])
- I have a few attributes on Department one being "Status" that has two children "attrib1" and "attriib2".
- Assume "Dept1" is tagged as "Same" and "No Dept" is not tagged with any attribute.
In Smartview if i pull data with no attributes, I'm good. But if insert the "status" attribute, "acct1" = #missing which makes sense given "no dept" isn't tagged with an attribute
In a perfect world, I'd like smartview to always return a value for "no dept" if attributes are present on my retrieval even though it doesn't an attribute association so that my acct1 formula always works. Alternatively is there a way to "cross dim" on a attribute association? For example if I could do something like this:
Tagged:
0