« previous next »
Pages: [1]

Author Topic: Filter on Transformer Model  (Read 1597 times)

Offline hrk551

  • Senior Member
  • ****
  • Posts: 72
  • Forum Citizenship: +0/-0
Filter on Transformer Model
« on: 19 Apr 2010 07:52:07 am »
I have a report running on PowerCube, It is taking long time to run the report, so I want to reduce the data in cube and I want to put a filter on cube Can I do that in Transformer model, give your suggestions on this and If possible give your thoughts on Cube optimization to run the report fast.

Thanks!
Logged

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Posts: 3,112
  • Forum Citizenship: +153/-3
  • Cognos Software Muppet
Re: Filter on Transformer Model
« Reply #1 on: 19 Apr 2010 10:43:22 am »
Hi,

More information is needed - sorry.  How is the report written against the cube - ie does it use detail/summary query filters?  Which studio/client has been used to write the report?  How many queries? 

MF.
Logged
Meep!

Offline hrk551

  • Senior Member
  • ****
  • Posts: 72
  • Forum Citizenship: +0/-0
Re: Filter on Transformer Model
« Reply #2 on: 19 Apr 2010 11:16:19 am »
Used Detail fliters in Report Studio and used 4 queries
Logged

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Posts: 3,112
  • Forum Citizenship: +153/-3
  • Cognos Software Muppet
Re: Filter on Transformer Model
« Reply #3 on: 20 Apr 2010 04:19:39 am »
Hi,

Sounds to me like you are using relational reporting techniques, which will often give poor performance against a cube.

Can you outline what the report needs to do - if so we may be able to suggest the appropriate dimensional expressions to use, and be able to do it all in one query.

Regards,

MF.
Logged
Meep!
Pages: [1]
« previous next »