Maximum Number of Parameters

Is there a limit to the maximum number of parameters that can be used
in Reporting Services when you render a report.
I hava report that uses about 35 parameters. the preview works fine but
when I deploy the report to the server and render no data comes back.
If I have 30 parameters it works fine.How much data is in those parameters? You may be bumping up against the
maximum length for a URL (browser GET).
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
<isam5030@.hotmail.com> wrote in message
news:1102471837.315758.229690@.f14g2000cwb.googlegroups.com...
> Is there a limit to the maximum number of parameters that can be used
> in Reporting Services when you render a report.
> I hava report that uses about 35 parameters. the preview works fine but
> when I deploy the report to the server and render no data comes back.
> If I have 30 parameters it works fine.
>

Maximum Memory Settings for Analysis 2005

Dear Anyone,

We have a live machine with an Analysis Services 2005 (32 bit) installed. The machine has been running for a couple of months. They recently upgraded to 8GB (formerly 4GB). It seems that the 32 bit version of MSAS 2005 does not support 8GB or memory. Can anyone please suggest memory settings to maximize the use of the 8GB of memory in the server? Or does anyone know of the maximum memory setup that we can give Analysis Services 2005?

Thanks,

Joseph

AS2K5 is not AWE-aware. As such, its capabilities are based on the underlying OS' virtural address space limitations. The general limits are (32-bit):

2GB -- with an OS that doesn't support the /3GB switch in boot.ini

3GB -- with /3GB enabled in the OS

4GB -- running on an x64 system under WOW

Otherwise, to go more, you need to run in native 64-bit using either x64 or ia64 hardware.

_-_-_ Dave

Maximum allowed value for integer in Analysis Services

Is there a maximum number up to which Analysis Services will do a SUM up to.

The reason I ask is that I get a negative number when I run the following MDX ([Mesaure] is aggregated with SUM)

SELECT [Measures].[Measure] ON AXIS(0)
FROM [Cube]

However each row in my fact table has a positive (and quite large value) for its Measure.

Thanks in advance

Stephen

Yes. There a maximun value of integer, I believe its just over 2 billion or so. When you first built your cube, AS defaulted your measure to the datatype in your source. You will have to change the datatype to a bigint, then you won't see those negative values.

Van Dieu

|||Sweet. Bigint it is. Don't know why it never occured to me to change the datatype of the Measure in Analysis Services.

Oh well, the simple things.