Thank you for the quick reply.
Do you mean that when you browse the cube in Excel and try to launch that action it doesn't show up?
Or do you mean that when you open the Tabular Actions Editor dialog it isn't there?
The text of the expression is in the Tabular Actions Editor. When I query*** the Model or use the Excel Additional Actions menu, the Action is not there.
I have been trimming the expression down further and further. I no longer suspect that it is a size issue. I have just a few lines and it’s failing as described above. I copy this text out of the Tabular Actions Editor (minus the “”) and run the DAX expression
in SSMS just fine. But the Tabular Actions Editor does not get it into the Model.
, LevelOfCare[ProfilerLOCCategory] = "Inpatient"
Thank you again!
*** The following query returns the list of Actions deployed in a Model associated with a particular Measure:
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">