May 7, 2013 at 2:53 pm
Hi, I have a cube with 3 partitions, and several dimensions. When I run the following query:
WITH DYNAMIC SET Top5Ip AS (
TOPCOUNT([Dim Host].127.0.0.1.CHILDREN, 5, [Measures].[Response Time])
)
SELECT
Top5Ip ON 0
,[Measures].[Response Time] ON 1
FROM [Fact Object Result]
WHERE ([Test Date].[Cal Year Hierarchy].[Day In Month].&[7]&[5]&[2013])
It gives error
"Errors in the high-level relational engine. The data source view does not contain a definition for the '[dbo].[dimPage]' table or view. The Source property may not have been set."
However if I move the data slice from "where" clause to TopCount function
WITH DYNAMIC SET Top5Ip AS (
TOPCOUNT(NONEMPTYCROSSJOIN([Dim Host].127.0.0.1.CHILDREN,{[Test Date].[Cal Year Hierarchy].[Day In Month].&[7]&[5]&[2013]}), 5, [Measures].[Response Time])
)
SELECT
Top5Ip ON 0
,[Measures].[Response Time] ON 1
FROM [Fact Object Result]
Any idea how I can fix this?
May 8, 2013 at 1:50 pm
Just got it solved. It is actually one of the dimension "Proactive Caching" was set to Automatic MOLAP instead of MOLAP. After I made the changes the MDX query runs through.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply