Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

NAMED SETS - Help Expand / Collapse
Author
Message
Posted Monday, December 24, 2012 3:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:23 AM
Points: 69, Visits: 141
Hi to all.
I use SSAS 2008 R2 and inside a cube i need to insert a NAMED SET.
I studied about NAMED SET and i was able to create new one , regarding my goal..

MDX Expression is this :

{([Azienda].[All Azienda].[COMET],[Settore].[Settore].[Settore].&[I],[Measures].[Importo Venduto]),([Azienda].[All Azienda].[CER],[Settore].[Settore].[Settore].&[I],[Measures].[Importo Venduto])}
It is a simply set with 2 different tuples.

BUT When i use Excel 2010 to display that named set inside a pivot tale, data visualization is different as i excepteced...


I can see all dimension members on COLUMN AXIS and Measures on ROW AXIS...
How can i do different ???

I need to display opposite, dimensions members on ROWS and Measures On COLUMNS.

I hope to be comprensive... Sorry if not...

I think it is very simple solution, but i am new of that kind of NAMED SETS....

Many thanks in advance and GOOD CHRISTMAS to ALL of you and yours families...

Ciao Mauro.


Post #1399851
Posted Wednesday, December 26, 2012 9:47 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:24 AM
Points: 802, Visits: 1,981
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].[.....]}



Post #1400288
Posted Wednesday, December 26, 2012 12:12 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:23 AM
Points: 69, Visits: 141
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...

http://projectbotticelli.com/knowledge/mdx-basic-concepts-unique-names-tuples-sets-video-tutorial?pk_campaign=cw2012cwb

===================
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
)








Post #1400326
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse