The user is the IIS anonymous user. At a guess I'd say that you/someone has allowed the IUSR account access (as you found that using integrated meant that those...

So you only want the two? Well, you could hard code that in to a parameter list (making sure you use MDX unique names for the values), or you...

I think the problem is my assumption that Electric is a level in the dim.

Are you looking to see Sector Types as the available options for the drop...

Am assuming that [ServiceCharge].[Sector Type].[Electric] actually has child members. If it doesn't, or you're looking for the members at the 'Electric' level (so am again assuming this is likely...

For what it's worth, I created a simple extract (2 fields, ints) from a single table in to a fixed width text file with limited issues. One of the...

Sounds like you didn't deploy the datasource to the server. Either deploy (the entire project, which will include the DS, with a default to not overwrite it) via BIDS,...

Yes, these can be changed. Read up on managing instances here and then navigate in win explorer to %Program files%\Microsoft SQL Server\90\Shared\ASConfig and review the contents of the...

Not sure that this is any better an option than going via the UI, but you could write your own deploy script, use rs.exe to deploy your reports and on...

Then you need to add a new column to the target to house the SSN data also.Do you control the target database?

I think Lynn has proven that you while you...

Different rows??

Um, different columns I can understand (ie one col for SSN, another for client ID). Different rows would indicate (to me) different tables, i mean, i certainly wouldn't...

Not sure if this will add significantly to your approach, but why not check the status of the Time dim in the beginning of the calc member and follow a...

BI Documenter comes to mind. It's not free but am pretty sure it does document the roles.

Note, if you're handy with C#, and this is *all* you want to...

Sounds like you're not overly sure *what* you want to do here....

Trying to concat two integers in to a new integer field is not overly a great idea. How...

Before reading/viewing/etc anything, go give it a try 🙂 In Excel 2007, go to 'Data' tab on the riboon, and then click 'From other sources' drop down and select...

Your design/deployment/etc all sounds pretty normal.

I haven't looked at Report Builder for a while, but last time i looked, the idea was that it was a report designing tool, not...