You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!