Hi,

Seems to me you suffer the double hop issue; Kerberos not enabled.

To solve this

Option 1:

Enable Kerberos Authentication

see http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx%5B/url%5D

Less secure and you use a generic account to access...

Hi,

It looks like the general issue after the MS security update MS11-100. This security update limits the max number of form_keys to 1000.

When opening the report in the Web...

Hi

Yes there is, and you could do it without breaking things..

Mr Russo and Ferrari created a nice paper called the 'Many-To-Many Revolution'. I presume this paper contains the directions...

Hi

I simulated your issue, I don't get any errors. However I had to change a field name

LICEDDATE vs LICDDATE in the IIF

My IIF

=IIF(IsDate(Fields!LICEDDATE.Value),FormatDateTime(Fields!LICEDDATE.Value,DateFormat.ShortDate),Nothing)

You evaluate the LICDATE and transform the LICEDDATE...

Hi,

In your action must look like:

http://YourServer/ReportServer?/YourPath/YourFile&rs:Command=GetResourceContents

YourFile should be stored on the ReportServer without the .pdf extension. It will be associated with the pdf application

See also:

http://msdn.microsoft.com/en-us/library/ms154497.aspx

Regards Kees

Hi,

Indeed your formula does not return a member in the second part of the Iif statemenet.

To overcome your issue: Lets try the following

Place the Aggregate function around your statement

it...

Hi,

Extend your IIF statement. It looks like this, new code in BOLD and Italic

FORE_COLOR =

IIF ( ([Measures].[CountOfRows] < 450

AND [DATE].[<Hierarchy_name>].CurrentMember.Level IS [DATE].[<Hierarchy_name>].MONTH[/i]

, 255, 0 )

Regards Kees

Hi,

You can obtain information of the Analysis Services objects with DMV (Dynamic Management View) statements.

See also: http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/

Regards Kees

I was working on more than one thing at the same time.

I placed the having clause in the column axis instead of the row axis

:doze::Whistling:

That does not work. Having...

My Fault, it now shows only lines where count > 9

replace > 9 with < 10

regards Kees

Try this

SELECT NON EMPTY {

[Measures].[AverageAchievementLevel],

[Measures].[AverageScore],

[Measures].[Fact Count],

[Measures].[Score]}

HAVING [Measures].[Fact Count] > 9

on columns,

NON EMPTY ([Com Student Demographics].[Race Ethnicity].Members)

on rows

from [ReportCard2007NoStudents]

WHERE(

[Com Organization].[Organization Number].[0001],

[Com Organization].[Organization Type Code].[03])

Regards Kees

See attached doc, this is an example of a SQL-Server-Agent Job step

Bobby,

Of course you can, when setting up an Analysis Services Command Job, you apply a value for the server. This is in the form: "Servername\InstanceName". The server can be the...

Hello,

To answer your question please read

When exporting to Merged cells row-heigths are not extend automatically. If you are able to get rid of the merged cells by carefully redesign your...

Hi,

Weighted averages are tackled at the bottom. To overcome your non leaf level wrong values, you have to create a calculated column in your fact table (DSV)

Step 1

Add a...