Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mdx Weird Error Message Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 2:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 5:48 PM
Points: 10, Visits: 113
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].[IP Address].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].[IP Address].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?
Post #1450336
Posted Wednesday, May 8, 2013 1:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 5:48 PM
Points: 10, Visits: 113
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.
Post #1450774
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse