Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Problem named set

Author  Topic 

Mayass
Starting Member

1 Post

Posted - 2013-06-11 : 07:51:19
I have created a cube in SSAS 2008 with set named which consist to filter my dimension calendar in order to show Data of the current Date,

then I have connected with excel to generate a pivot table but when I want to open this file.xls on anther machine it didn't work and i can't find my named set on the pivot table.

Is there any solution to import my pivot table with the named set?

thank you

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2013-06-25 : 03:47:42
Can you see the named set in Management studio?
Could you paste the code you used to create the named set?


Duane.
http://ditchiecubeblog.wordpress.com/
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-25 : 03:52:01
see

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/23cb7a00-328d-48f7-901c-7f346cc3ecc0/cant-see-named-sets-in-excel-2007

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -