Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DSO and Dynamic Dimension Security
Has anyone tried to set up dynamic dimension security http://support.microsoft.com/default.aspx?kbid=828343 using DSO? Is it possible to get double quotes into AllowedSet In the example for allowed members the MDX is STRTOSET(IIF(USERNAME="", "{}",SETTOSTR( GENERATE(...- Acius
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Optimize Schema and Private Dimensions
Is there a way to run 'Optimize Schema' on a cube using private dimensions? The cube has a number of parent_child dimensions which have source table filters specified. If I create the cube using shared dimensions and select optimize schema it works correctly and only the fact table is queried...- Acius
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Bending Time
I'm trying to represent time in a couple of different ways without building multiple cubes. Usual way Jan 01 Feb 01 ... Dec 01 Jan 02 ... Dec 02 To make it easier to report is there a way of 'breaking the time dimension into 2 dimensions e.g 1 Dimension with Jan Feb ..Dec and another with year...- Acius
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
