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

Dimensional prompts

Started by CognosMarson, 02 Jan 2020 09:22:34 AM

Previous topic - Next topic

CognosMarson

Hi, I stumbled upon this query

tuple(
    currentMember ([Member1]),
    currentMember ([Member2]),
    [Time].[Calendar].[Month]->:[M12].[[Time]].[Calendar]].[Month]].&[201504]]],   
    [Measure]
)


Can someone please explain to me what "->:" and the ".&" do?

/CM

CognosPaul

The memberuniquename you posted appears to be from SSAS. The ->: bit separates the key on the right from the hierarchy or level on the left.

The structure changes a bit for each different OLAP solution. In this the ampersand is delineating the actual business key for the month.

CognosMarson