-
MDX Query
I Just cannot find the correct answer for what seems the most simple thing
I am Creating a KPI in Dashboard Designer the KPI is for Total Quotes for the Current Month, I can create the query but i would have to change it every month which i dont want to do so i need it to be Dynamic.
I have a time dimension which is as follows
[Time].[Year - Month - Date]
I have tried the following
([Measures].[Total Quotes], StrToMember("[Time].[Year - Month - Date].[Month].&["+CStr(Format(Now(),"yyyy-MM-dd"))+"T00:00:00]"))
but it just returns a value of null
somebody must know how to do this
John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|