December 26, 2012 at 9:47 am
The Named Sets in SSAS isn't quite like the named Sets in MDX. In SSAS, the use seems to me to be limited to listing dimension members, not creating reports that combine dimension members with measure. This limited use can still be useful as it allows you to create a set and then set the options to show every row (or column) so that Excel based reports have a consistent format.
You create these in the calculations section. The result then appears under the Named Sets in the dimension to which the set belongs unless you have specified a specific display folder. Here are two examples of how I've created named sets. The first I used the warehouse identifier (hence the "&" symbol). The second I used the actual name of the client, though I have dotted the actual name out.
This took a bit for me to figure out. It's more abstruse that I would have liked, and I'm not sure I've grasped the full range of possibilities. Maybe someone else would like to weigh in and add something.
{[Primary SKU].[SKU].&[700],
[Primary SKU].[SKU].&[717],
[Primary SKU].[SKU].&[522],
[Primary SKU].[SKU].&[591]}
{[Campaign].[Client].[...],
[Campaign].[Client].[....],
[Campaign].[Client].[.....]}
December 26, 2012 at 12:12 pm
Ciao.
First of all , many thanks for your kind reply.
I understand what you wirtten , so i thank you very much...
Fortunately i discover also a good tutorial of C.Webb about MDX concepts SET and TUPLES, so now i am bit more able to do something, even if MDX is not very easy so every time it is difficult to do something..
My problem was to do an INTERSECT to obtain same members about a CUSTOMER dimension.
In fact i have in my scenario the same custoemr code in 2 different companies whose data in the same DW.
So i was able to dot that.
I think NAMED SETS are very useful,,,without them i never obtain my purpose...
I could display all customers about 2 companies but i would do a visual serach to discover same customer codes...
Here is my sample and tutorial that opened my strange mind...:-)
===================
SET 1
====================
FILTER ([Stat_Resp_Age_Cli].[Gerarchia SOLO CodiceCliente].[CodiceCliente].members
,
[Azienda].[Chiave_CodAzienda].[2])
===================
SET 2
====================
FILTER ([Stat_Resp_Age_Cli].[Gerarchia SOLO CodiceCliente].[CodiceCliente].members
,
[Azienda].[Chiave_CodAzienda].[1])
=======================
SET USED IN Excel to obatain data i wanted
=======================
INTERSECT
(
[Set Clienti CER]
,
[Set Clienti COMET],ALL
)
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply