COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: CognosMarson on 02 Jan 2020 09:22:34 AM

Title: Dimensional prompts
Post by: CognosMarson on 02 Jan 2020 09:22:34 AM
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
Title: Re: Dimensional prompts
Post by: CognosPaul on 03 Jan 2020 10:50:54 AM
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.
Title: Re: Dimensional prompts
Post by: CognosMarson on 06 Jan 2020 01:58:11 PM
Ok, thanks!