Traditional web-based reporting with SAS BI tools

OLAP Prompts with Special Characters

SAS Employee
Posts: 238

OLAP Prompts with Special Characters

Just discovered an interesting item on OLAP Prompting in Web Report Studio.

First, if you experience special characters in a prompt and return an error message stating something is wrong in the cube name, remove spaces in your cube name.

Second, if you have the specific special characters: [ ] existing in your prompted value this will cause an error because brackets are used in MDX code to define members. I'd suggest that you change these to ( and ) in the data or at the OLAP cube building step.

~ Angela
Ask a Question
Discussion stats
  • 0 replies
  • 1 in conversation