MDX in Excel?

[image2x]

I'm wondering if I can utilize an MDX statement in an Active Form?

Instead of:
=TM1RPTROW($B$9,"planning:Merch Hierarchy","MDXSUB-CLSAAAC")

I'd like to do something like:
=TM1RPTROW($B$9,"planning:Merch Hierarchy","{ [CLSAAAC].Children }")

But after making the above change to TM1RPTROW, F9 doesn't update anything and a rebuild Active Form command takes forever and returns the entire hierarchy. I want to have [Dimension] referenced from a SUBNM selection in another cell. After the selection changes, I'd like to have all Active Forms in the workbook refresh to reflect the childern of this selection.

If I can't do this, I believe I'm going to be stuck manually creating 400+ MDX Subsets (or figuring out where/how mdx views are stored and modifying the TM1 reference file directly).

Thanks. -- John

[Wim Gielis]

Hi

You can split up the MDX statements to reference cells, like here where you reference cell A1 for the SUBNM:

"{ [" & A1 & "].Children }"

Also, check out if the position of MDX statement in the formula is correct. I thought it comes after some more function arguments in TM1RPTROW.

Wim

[image2x]

Wim, thanks for the help. I didn't realize their was a specific parameter for MDX statements in the TM1RPTROW statement.

Now, does any know if there's a way to force all active forms to be rebuilt after a selection changes in a websheet????

[Wim Gielis]

I would prefer an Action button to do the update of the active form.