Hi,
I know that this might not be the right forum as it is for SQL language and my question is about MDX syntax, but as I have had a lot of help from here before I give it a try anyway. Ther might be someone who knows.


I have the following question

="SELECT {[Measures].members} on columns, NON EMPTY CROSSJOIN([aktor].[aktor].members, [Innovation].[utl].members) on rows FROM MedFact WHERE (" & Parameters!pFinance.value & ")"

I have populated one dataset for the "pFinance" parameter and one for another parameter, "pTime"

My question is; What is the correct syntax to add the pTime parameter so I get a AND in the where clause? What I want is something like: SELECT ...... WHERE pFinance AND pTime

Thanks in advance

Let me give a try,

WHERE (" & Parameters!pFinance.value & " AND " & Parameters!pTime.value & ")"

Does this help?

_________________________
- Vijay G
Strive for Perfection

I found the right syntax. The where clause should be like this

WHERE (" & Parameters!pFinance.value & ", " & Parameters!pTime.value & ")"

Oh... that was different from normal usage of where in T-sql. But I did a lot of search on the net, could not find one for you, so did a guess. Glad that you found it.

Cheers!

_________________________
- Vijay G
Strive for Perfection