If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Get String Values Using Dimensional Data Source

Started by i_am_john, 11 Dec 2019 12:58:32 PM

Previous topic - Next topic

i_am_john

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?

CognosPaul

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]