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) |