You could take a look at custom rollups or calculated cells. But this could end up being a lot of work to di through a large (many dimension) cube....

Not sure I follow you re: formatting. Did you go to the actual cube itself (ie using Analysis Manager -> Edit Cube) and set the format of the measure/s...

Hi Ardley,

You could also take a look at

http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-4586-A13C-50E56F101720&displaylang=en (watch out for line breaks). The toolpak contains a sample for drill through from OWC.

HTH,

Steve.

Are you sure that there hasn't been a default/catchall applied when loading the fact records? Our dates have always come through as null when null, unless specified otherwise. ...

Hi David,

What are your measures (the values you want to see in the middle of the crosstab)? Is it an answer count or something completely different (ie not in...

Have you tried formating the values within the measure properties (ie in the cube/model)? This would be the first place to start, this will ensure that the formatted value...

Upgrade plan is what we have done before with success (geez I hope I'm not jinxing you now!)

WHen you're talking 'dump' here you're meaning Backup? I would still archive...

Thanks for the replies. So the consensus is that the Globals are one-way only, bit of a pity really. Guess I'll have to change my logic/flow to...

Hi Michael,

Rosetta and Reporting Services are one and the same. The code name is for Reporting Services not for any particular piece.

More info on RS can be...

Not sure I understand your logic here....

If you have inserted 'missing' into the foreign key column, how are you expecting to update it it to a valid key value? ...

Hey Alan,

Have you tried using these in the WHERE clause (slicer specification)? This will slice the data to include only the dat you want. Obviously this isn't the...

You might want to check the repository path/address for remote connections. Sounds like there could be an issue there.

Right click on the server name and select 'Edit Repository String'...

Hi Bart,

have you tried the concatenation operator of || (pipe pipe)?

So your formula would be

'Quarter ' || {fn QUARTER("AAW"."ABPA_C903_CY"."POSTING_DATE")}

If this doesn't work, do you need to specify the Concat function...

Hi Marcos,

It sort of depends on what type of semi-additive measure you want to add. Distinct Count can be selected from the 'Aggregate Function' property in the properties sheet...

Typically you'd do this using look-ups but these are a little slow in DTS (SQL 2K). If you can, load your data to a staging table and do your...