OK, I think it has something to do with the INT IDENTITY key I've placed on my SQL tables. For those tables whose primary key is an integer determined...

Sorry Stefan, it's been a long time and I honestly can't remember what I did.

I've since stopped using ADAPT and started using BI Documenter http://www.bidocumenter.com/. It is retrospective (documents...

Hi Ian,

FYI there is a tool in SSIS which creates a Slowly-Changing Dimension update package. A slowly changing dimension is one which has changes which may or may not...

Satish,

You'll have an IIS-based installation of reporting services somewhere in your organisation. It will have a /ReportServer directory, from which you can download the report definition. You also...

Hi Satish,

It really depends on the type of report query you're using (SQL, MDX, ??) and what you want to use the parameter for.

You can find Report Parameters under the...

Hi Dave,

I'm probably looking at your problem too simply, but there's an MS tutorial on defining dimension attribute sort order here (open in IE): ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/67dacf68-9ab7-4524-8698-844d0f6e6c6d.htm

Whether or not this achieves your...

I'm using Reporting Services to pull the values through (this is my end goal) and it doesn't show them. Looks like I might have to go back to .Properties...

Fantastic, thanks for such an informative response.

Ah yes, that's done it, wonderful! Thanks David. I feel like a bit of a goose.

That's done it, thanks Dave!

Thanks Steve,

Unfortunately the use of the Parent function there refers to a member as opposed to a set. That is, it will only show the parent for a single...

Thanks Stefan; so you didn't find a way to do it in the new MDX writer? I would be great if I could refresh the field list without having...

Hi Dave,

Thanks for the response. I'm still not clear though on what the syntax is for referencing report parameters in MDX queries. I recall it was Parameters!p_paramName.Value in...

Turns out I was using the AverageOfChildren aggregation function on one of my un-calculated measures. I still don't see how this is a semi-additive measure, given that it's not...

Thanks, worked a treat. Makes sense when you think about it