Have you added any custom assemblies to the SSAS instance?

Hi George,

I'm glad you figured it out - apologies, I had gone home for the weekend and I don't even like to think about this sort of thing at the...

Probably the best way to achieve this would be by implimenting Role Based Security in your OLAP database. Here[/url] is a good article about it all.

You could generate a calculation in your cube using ParallelPeriod. Then you can use your Date dimension to slice and dice the data as you need. A simple example would...

What specific error do you get?

Forget that - have a look here[/url]

🙂

I had a similar thing once where I had to so a sum of a count only for an unknown year and excluding certain statuses.

I did this

SUM({(FILTER([Repair Date].[Year].MEMBERS,[Repair Date].[Year].CURRENTMEMBER.NAME...

Fishing is cruel

Well Greg has gone right ahead and answered the question not directly but brilliantly. I would listen to him - role based security in ssas is incredibly powerful and completely...

Ah so it's SSIS.

To be honest with you, problems with deployment don't happen so often - as long as the account doing the deployment has permissions to deploy packages...

What are you deploying? What errors are you getting? Please be more specific

BI Documenter from Pragmatic Works is pretty good and would do what you need. It will set you back a cool $595 though :ermm:

In SQL 2012 you have the SSISDB...

You can put parameters on the report and then have specific parameters for specific subscriptions, filtering the data by the user's needs.

When you say assembly do you mean in the sense of say, a .net assembly? If so you can add these to your AS server instance. Have a look at...

If you have the packages stored in the SQL Server then you could do something like this:

SELECT Name, CONVERT(xml,CONVERT(varbinary(max),PackageData)) AS PackageSource

FROM msdb.dbo.sysssispackages

WHERE CONVERT(varbinary(max),PackageData) LIKE '%Your Table Name%'

It's...

You're welcome Dave 🙂