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
Quote from: lalitha.nov20 on 05 Nov 2015 07:18:15 AM
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.
Yep - PC indicates it's a Cognos Powercube.
MF.
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
Quote from: lalitha.nov20 on 05 Nov 2015 11:13:27 PM
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.