dbTalk Databases Forums  

OWC Query

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss OWC Query in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Williams
 
Posts: n/a

Default OWC Query - 12-13-2005 , 11:33 PM






Does anyone know what this query is:
select filter([Measures].members, [Measures].currentmember.member_caption =
[Measures].currentmember.member_caption) on columns from [Focus DW]

When we send a query from OWC11 this is the first query that is sent, then
the queries that actually return the data we are interested in. The result of
this query is basically an aggregation of every measure in the fact table.
The problem is that when this is sent to a cube on CTP15, it takes less than
a second. When it's sent to an identical cube on the production release it
takes more than 30 seconds.

Any ideas why this is sent, what the results are used for, or how we can
make it return the data faster?

Thanks,
John Williams

(If the answer is to design an aggregation for this specific query, I may
need a little direction on that as I have never done any custom aggregations)

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.