I got it to work. Not exatly sure why but it works as supposed for both hierachies is I take away the first one, maybe it has somethink todo with...

Thanks for your input.

To keep them apart is the best way to go forward in case of reloading failure etc.

/Michael

Hi Koen

With the new dimensions it is possible that the transformations will change the grain.

Mike

Hi

I did not get into trouble, it went very smood. I did a backup/restore and changed all the compability levels and started monitoring the performance to find the bottlenecks.

I didn't...

Hi

I believe that when you call a Stored procedure with a multivalued parameter with strings they are sent as:

'Jan,feb,Mar,Apr' etc

I think you nedd to parse the parameter in...

Hi

I have the same problem. In SSRS 2005 when you use hidden property on columns the column is hidden when you export the report to CSV, but in SSRS 2008...

Hi

ssrs 2008 is not using IIS. It has its own webserver, ithink default location is

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER

/Michael

Hi

On the group Properties - Visibility you can choose an object that will toggle visibility of the groups that will exband or collapse the details

/Michael

Hi

It has been solved. It was a userrights-issue.

Thanks

Michael

Hi

When looking at the picture it seems that you are missing the & before concatinating the starttime dts variable.

/Michael

Hi

What I have found useful is:

1 Envirionment Variable containing the path to the default configfile on every machine.

Ex. K:\SQL\Confiurations\DefaultConfig.XML

In that file you put the connectionsstrings and default paths to where...

Hi

Using pgp.exe is throwong Open File security warning.

I have changed the internet settings att get the package to execute right under the logged in user.

But when a execute...

Hi

I think you need to set up a Linked Server between the vacancy SQL-servers and the insightSSRS SQL- server to get that to work.

/Michael

Hi

I don't know if you solved the problem. My problem was with the exchangeserver sending the mail. It was configured not to relay external, and resulted in the same errormessage.

/Michael

Hi

I solved my problem with filters in my descendants funcion calls

union (Descentants(Filter(PurchaseHeadmanager)), Descendants(Filter(PurchaseManager)))

Before I applied the Descendantsfunction on the dimensionmember, when I actually needed a set of members because the...