Hello Jack.

All (sub-)reports are in the same Solution.

The problem exists in both, DevEnv and ReportServer(made a upload, hoped i get a better error message).

Tobias Boehler

Hello There.

Here some additional informations:

I get the error: "HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials"

Credentials AppPool: "Network Service"

Credential WebSite: Windows Auth.

Credential VirtDirect.: Windows Auth.

As Credential...

Hello Lonv.

I found out the problem is caused by the website where the virtual directories are in.

For publishing the website I put a IP-adress in and made some host header-entries....

Hi again.

I implemented the query in different variations to some StoredProcedures and increased the query-time from 30 seconds (OLTP) to 2 seconds (OLAP). 🙂

In another query I...

GREAT !!!

Now it works. Had to do some little changes. Here the corrected version.

WITH

MEMBER [Date].[Range] AS 'sum([Date].[2005-01-01]:[Date].[2005-01-03])'

MEMBER [Measures].[Distinct_Patient_Count] AS 'count({nonemptycrossjoin({[PatientID].children}, {[Measures].[Count]})}, excludeempty)'

SELECT

{[Gender].children} on...

One step closer...

The COUNT-function works nearly fine now. The problem now is, the EXCLUDEEMPTY-flag excludes no PatientID, because the PatientID itselfs is not NULL -> empty PatientID-values should be excluded....

Another Information:

I cannot even count the Members

count({[IBIdim_LEP_PatientID].members}) on 0

---->--- "cannot convert expression to set"

Must be a understanding problem on my side...

Hello again.

>> Can you tell us how you'd like to see the output?

>> ie on row, on columns, filtered by .

Okay. Now you get the actual...

Hi again.

This query returns the same values like in the first thread(time is good, below 1 sec):

With

MEMBER [Datum].[Range] AS

'sum([Datum].[2005-01-01]:[Datum].[2005-01-01])'

SELECT

non empty nonemptycrossjoin([PID_FID].[PID_FID].members) on 0

FROM IBIcube_LEP_AKZ1

WHERE ([Datum].[Range], [Geschlecht].[weiblich], [Stations_Gruppe].[M Chirurgie], [Fremdstationaer].[Alle...

Hi Steve,

with this query i get for each patientID (PID_FID - all members 60.000 entries) one column. The count on this columns with the above set filters return the correct...

Sorry, Subject should be named as:

Count members of dimension

So easy.

Great, thank you.

Wish you a nice evening.

Tobi

Hello

Short statement to the testings.

I did a lot queries yesterday and had no differences to the origin data.

Thanks for help everybody.

Tobi

Good morning Steve,

now it dawns on me 🙂

What a great monday.

My _wrong_ thought was:

The cube ignores the other partitions. But of the wrong slicer-statement in the...

Hello again.

Thank you for this informations. Now i have another problem. I made a partition and set the

"Data Slice" on [Date].[2005].[Q1] and the

"Filter Statement" with

CONVERT(DATETIME, '2005-01-01 00:00:00', 102) <...