SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


NAMED SETS - Help


NAMED SETS - Help

Author
Message
maretix
maretix
Old Hand
Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)

Group: General Forum Members
Points: 307 Visits: 234
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.
RonKyle
RonKyle
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2770 Visits: 3501
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].[.....]}




maretix
maretix
Old Hand
Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)

Group: General Forum Members
Points: 307 Visits: 234
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
)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search