Thanks for your help.

Sorry, I may not have explained myself correctly. This change needs to be carried out automatically on the fly as the 0 or 1 value controls part of a ETL.

SSAS relies on MS Windows authentication to authenticate users. After a user has been authenticated, Analysis Services controls permissions within the databases based on the user's role membership.

Open your SSAS...

Other than manually typing the friendly name property for a particualr field you mean?

Grant, thanks for your reply I also found your article you posted interesting today.

I need to read your last post again to make total sense of it as I am...

Guys, thanks for your suggestions.

In reference to Grant's post this solution would still require user intervention to set the variable at each command line, wouldn't it? Or am...

Hi thanks for your reply. This is actually what we currently use - Team Foundation Server we call it!

I would like to set the db extended property value to something...

Thanks Jeff,

In terms of adding a data source though how would I go about this? Firstly I set about creating a new shared data source bringing in the fields...

Wow, I heard it was straightforward. But that, and probably many other things are a vast improvement over DTS!

After successfully passing this exam a couple of months ago I now have the self paced training kit for 70-442 up for sale if anyone is interested?

http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&rd=1&item=290182484020&ssPageName=STRK:MESE:IT&ih=019

I used the self paced training kit from Microsoft and trancender. I am selling this training kit on ebay for only £4.99 if you're interested?

http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&rd=1&item=290182485412&ssPageName=STRK:MESE:IT&ih=019

Thanks. I used the FORMAT function in the end and this worked great.

Thanks again to everyone

I should have made you aware that my dates appear as required in my results set but the formatting is changed when rendered on the report.

I actually solved this in the end.

My solution was to exchange steps 2 & 3 around. This meant I was dynamically creating the overall structure of the table first and...

Thanks for your help - that worked perfectly