Hello All,
I am facing an error while using substring function on dimensional reporting in report studio.
I am using the below method to get the month name.
substring(caption([Fiscal Month]),1,3)
This gives me the below error:
XQE-GEN-0010 : Found an internal error: 'MUN without its level'.
Cognos version is 10.2.1
Any help?
Thanks in advance.
Hi
From the look of it, you are trying to display a 3 character month name.
Maybe you can add a Member Description at that level (in case of DMR; Short Name attribute in case of cubes) that stores this value and use that in the report.
Let me know if this is helpful
Hi Adam,
Thanks for the reply. It is SSAS at the backend.
Yes it is possible to create a new item. But I wanted to find out what is causing this error.
Normally it should work as per the samples given by IBM.
String functions, like substring are not supported in OLAP. You'll be forcing Cognos to run local processing. Read this: http://cognospaul.com/2010/11/29/the-importance-of-using-report-expressions/ (http://cognospaul.com/2010/11/29/the-importance-of-using-report-expressions/)
Thank you very much Paul. This was exactly what I wanted. :)