[Solved]substring() on a dimensional data source

[Ammus1234]

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.

[Adam_Clone]

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

[Ammus1234]

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.

[CognosPaul]

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/

[Ammus1234]

Thank you very much Paul. This was exactly what I wanted.  :)