Skip to Content

Problem with universe OLAP Microsoft Services

Hello guys,

I have a problem in the generation of a universe in Microsoft OLAP Services. I explained my problem, I need to create a Webi report  to schedule weekly  execution, this report must have a filter that It always takes the last four weeks so that the filter needs to be dynamic. I was thinking of generating a predefined filter in the universe to do this directly but It doesnt work.

This is the coding I've used.

<FILTER KEY="@Select(UPA Week\WEEK)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="">select datepart( week, getdate())</CONSTANT></CONDITION></FILTER>

The analysis of the sentence is correct but when I apply the filter never returns the report data.

Can you help?

Thank you very much.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 03, 2012 at 03:08 PM

    Hi,

    There is an SDN document here with some OLAP .unv predefined filter samples here:

     

    https://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/c0a45246-ce76-2b10-e688-f5c8206203eb&overridelayout=true

    Good luck!

    Regards,

    H

    Add comment
    10|10000 characters needed characters exceeded