Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
MDX working in Select, but not in calculated member
March 19, 2012
I am trying to calculate how many closed tickets there are in the same date range as received tickets, even though they are different date dimensions.
This query works with a select, but not as a calculated member:
+ [Received Date].[Weeks].CurrentMember.Member_Key + "]"
,[Measures].[Call ID Distinct Count]
, [Received Date].[Weeks].[Week].MEMBERS ON 1
The error I receive when I tried it as a calculated member is "The 1/1/2009 string cannot be converted to the date type."
Interestingly, it does calculate the All member.
Thank you for your assistance.
Posted Date: April 10, 2012 Points: 20
Data Type of Date Column .you are setting the date column's Data type is string.So change to Date column data type into DateTime.Please backup your database and change the Data Type.
Regards, Lakshmi Naraayanan.S
To post reply
Related Questions Related Questions
Select File button not working in ajaxfileupload control
How can we select a particular row in the listview control
User can not select TEXT for copy paste from my .aspx page...
one project are work in two member we are divide equal form we are join this form to one to copy to form dost not copy to form many time try to way but cannot copy how its copy or join for two form ?
How to get business or working day in a month in c#
How to add a button to calendar control which shows years.so that I can select particular year.
What is IDE and its Working
SQL Server 2005 - Working with IDENTITY column
HTML Line Break tag is not working in Chrome browser
Select multiple item using Control key and mouse click in Silverlight
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend