I have a Cognos 11 report using an SSAS cube as the data source. My report is a simple list using a single dimension and several measures.
The single dimension attribute we are using is for a project and I am trying to figure out if I can use data for that project to create a hyperlink to a different internal site. However, I am having trouble extracting the string for the project number member to use within the URL.
When I concatenate [Cube].[DimProject].[ProjectNumber].[ProjectNumber] into my URL I get an odd error below:
Internal error. The query could not be planned by the Query Service:
MacroException - a parsing error was encountered in the macro:
Encountered "[" at line 1, column 5.
Was expecting one of:
<INTEGER_LITERAL> ...
<STRING_LITERAL> ...
"$" ...
"%" ...
"@" ...
")" ...
"case" ...
<IDENTIFIER> ...
I tried using roleValue('_businessKey', currentMember([Cube].[DimProject].[ProjectNumber])), but that just returns a 0 for all items.
Is there a way to get the string values for these members?
Use a report/layout expression to concatenate the string instead of doing it in the query. The caption is accessible as a string.
'http://server/whatever?key='+[Query].[ProjectNumber]