Hi Jeremy,

I used the following to add a linked server (using QA) but I would suggest taking the appropriate pieces and put them in right places in the GUI version...

Hi Hfrank,

Such an easy request but so hard to do....

I spent ages looking at how to do this at design time (I wanted this measure too!) but with no...

Hi Steve,

I was about to suggest the registry for checking the conxn string, but it loks like it's been encrypted .

Another question though - the AS service...

Hi Chris,

You *should* be able to have the calculated member reference another dimension. One gotcha I can think of here is that your calculated member formula must handle the...

Hi Mike,

Quick question - Do you have dimension tables in your model also? If so, are you sure your joins are correct? When the cube processes (if done...

Hi Steve,

Just out of interest, have you looked at the Repository conxn string (from AS Manager, RC on the server name and select 'Edit Repository Conxn String'. Does this...

Hi Marco,

Yes, I do mean adding the calculated member to the time dimension. Creating this member can be hard or easy, it really depends on the format of the...

Hi Michael,

SOrt of left field, but maybe in line with the server chanegs you mentioned - has the long date (or short date for that matter) setting on the server...

Marco,

There's no way you can convince the client to use a calc member for YTD in the time dimension? It wouldmean they could use YTD for any given measure...

Hi Marco,

Yeah, perfromance with distinct counts can be an issue. I'm neck deep in conversations with Msft currently about the client Vs server processing of queries.

What I can offer you...

Hi Michael,

I didn't want to put that in last post, but the searches I did all raised potential (DB) security/access issues (with SQL ole db driver).

I think that doing a...

Hi Michael,

The error code seems to be suggesting the MS SQL OleDB driver is cuasing some issue(s). Have you done any tracing/monitoring of the DB when trying to build...

Remembered the other control, Snowflake (now at v2.0 I believe) from Intellimerce. I think I tried out v1 but haven't tried out v2.0 as yet, so can't offer comment...

I would say that office web components are probably the closest, but there's a couple of others around. Still in beta (been in beta for quite a while

Hi Shaki,

Yes, you can 'export' the cube to Excel (as a .cub file).

What you need to use is the Offline Cube Wizard within Excel. The way...