Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

performance probs ..anyway please help

Status
Not open for further replies.
luk4u

luk4u

IS-IT--Management
May 15, 2003
2
0
0
IN
Hi All


Please let me know anyway I can get around in writing this type of query in analysis manager mdx expression it is taking longtime to load and edit.

Filter ({GENERATE({[x_DIM].[All x_DIM].CHILDREN},{TopCount({[AC_DIM].[empno].members}*
{[x_DIM].[All x_DIM].CHILDREN}, 25, ([Measures].[ BALANCE]))})},Isempty([Measures].BALANCE] )= False)

please correct it
 
Status
Not open for further replies.

Similar threads

msasnewb
  • Locked
  • Question
Help with calculation in analysis services
Replies
1
Views
48
Recce
Recce
bebbo1986
  • Locked
  • Question
Performance Problem from SSAS
Replies
6
Views
17
bebbo1986
bebbo1986
Solo4357
  • Locked
  • Question
Help with query...
Replies
0
Views
20
Solo4357
Solo4357
eo
  • Locked
  • Question
MDX IIF statement help. Can IS TRUE be used?? 1
Replies
4
Views
43
eo
eo
pwomack
  • Locked
  • Question
Help with dimensions when creating a cube
Replies
1
Views
28
pwomack
pwomack

Part and Inventory Search

Sponsor

Back
Top