Undertanding MUN Of reportstudio

[lalitha.nov20]

Hi,

Can anyone explain me what is [PC] refers to in the below syntax.

[great_outdoors_company].[Years].[Years].[Year]->:[PC].[@MEMBER].[20040101-20041231].

Thank you,
lalitha

[Lynn]

Hi,

Can anyone explain me what is [PC] refers to in the below syntax.

[great_outdoors_company].[Years].[Years].[Year]->:[PC].[@MEMBER].[20040101-20041231].

Thank you,
lalitha

I think it is telling you that the source is a power cube.

[MFGF]

Yep - PC indicates it's a Cognos Powercube.

MF.

[lalitha.nov20]

Hi,

We get some number like [M14] IN Case of SSAS cubes. how is it calculated or how do we get it.

Thank you,
lalitha

[MFGF]

Hi,

We get some number like [M14] IN Case of SSAS cubes. how is it calculated or how do we get it.

Thank you,
lalitha

It's a technology identifier, built in by the manufacturer of the cube technology. M14 appears to be a Microsoft Analysis Services 2014 identifier. I don't believe there's a guaranteed set way to calculate it - you need to examine the MUN of a cube member to see if it's there and how the manufacturer decided to populate it.

Here are some examples:

MSAS 2012 MUN:
[GO Sales Fact].[Product].[Product].[Product Line Code]->:[M12].[Product].[Products].[Camping Equipment]
Cognos PowerCube MUN:
[great_outdoors_sales_en].[Products].[Products].[Product line]->:[PC].[@MEMBER].[991]
TM1 MUN:
[Market Strategy].[Product Lines].[Product Lines]->:[TM].[Product Lines].[Product Lines].[@MEMBER].[Alpha]

MF.