Hi

Sorry to answer my own post but I have found the correct solution:

Iif ( IsEmpty ([Measures].[Volume]), null,

Rank(

[Entity].[User Name].CurrentMember,

Exists ([Entity].[User Name].[User Name],

...

Me again ... 🙂

If you don't want the totals to show in Excel, just tick the "Enable Visual Totals" box in the "Dimension Data" tab of the Role and voila!!

I...

Sorry to reply to my own post again but I have made some progress.

In the Role if I specify a Default Value in my "Dimension Data" tab I get the...

Hi

For anybody interested I have managed to solve part of my problem.

I have removed the <domain>\<user> from the list of Users specified in the Security properties in Management Studio.

In Excel...

Hi

Thanks for your reply.

I have finally managed to get round my issue by modifying my DSV Dimension Tables in order to include a -1 Id associated to an "Unallocated" entry....

For anybody interested here is the solution:

import java.io.FileOutputStream;

import java.io.OutputStream;

import javax.xml.rpc.holders.ByteArrayHolder;

import javax.xml.rpc.holders.StringHolder;

import javax.xml.soap.SOAPElement;

import org.apache.axis.client.Call;

import org.apache.axis.message.SOAPHeaderElement;

import org.apache.log4j.Logger;

import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.*;

import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.holders.*;

public class GenerateReport {

public void GenerateReport(String...

Hi

Thanks for taking the time to answer my question.

We can access the report directly by selecting the hyperlink. The report displays and render nicely in IE so there is no...

This may be due to the fact that you do not have a file with the correct name in the directory specified in the properties of your Container.

Put an .xls...

Hi

Please bear in mind that this is only part of the solution you are looking for.

In the past I have used the following in order to loop through different Excel...

Here is my solution which may not be the best but here we go:

(<dimension0>.&[VALID], measures.Count) + (<dimension0>.&[INVALID], measures.Count)

Voila sorted!

That gives me the number of records which are either VALID or...

Hi

Thanks for the answer.

Unfortunately when I do that I get the following error:

"The <dimension0> hierarchy appears more than once in the tuple.

Cheers

Ludo

Hi

Unfortunately there are more options that just VALID and INVALID so I need something to filter the result.

Cheers

For anybody who's interested here is the solution.

Let's say that you have a meaure that tells you how many records you have in your set. That's an existing measure presented...

Still no joy I'm affraid.

Following more testing it down on me that if you create a Member which uses only Measures from the Cube the Where Clause is used. If...

Thanks for the info.

I will investigate and will hopefully find an solution.

Cheers