Search results for query: *

We had the same problem. The connection only worked if you didn't specify the username/password. Problem is we don't have domains; so had to set up a user with the same userid/password on the server. Only other way around was to use a HTTP cube and basic authentication. I'm not sure what the...

There's a limit of 255 levels in a cube. We were trying to build a cube with a heap of different hierarchies (ragged and parent-child so could use virtual dimensions) and hit this one.

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(...

Thanks MDXer, That's fine for the Analysis data source. Since we can't rely on domains we were trying to figure out if we could authenticate the cubes (and set appropriate cube roles) against the SQL Server database users (since users are used to these user ids/passwords) Cheers

Hi, Is there a way of getting Analysis Services to authenticate against an SQL Server database user? Thanks

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...

Thanks, but what I was really trying to do was present as simple a view as possible (mainly for graphing purposes) to the user. e.g. in the first case the table would be Jan Feb Mar .... Dec 2001 10 20 30 .... 2002 11 19 29 ... This makes it dead easy for users to produce a graph that...

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...