Skip to Content
avatar image
Former Member

Predefined filters in OLAP Universe

Hello

I am trying to create a pre-defined filter in an OLAP Universe on top of SSAS 2008. We use BOXI 3.1

Here is my object Structure

Date(Folder) -> Year(Folder) -> Year(Dimension object).

However when i try to create a simple filter as below

<FILTER

KEY="[Date].[Year].[Year]"><CONDITION

OPERATORCONDITION="InList"><CONST

ANT CAPTION="@Prompt('Calendar

Year(s)','A','Date.Year\Year',multi,constrained)"/></CONDITION></FILTER>

I keep getting "Parse Failed UNV0023 Invalid Definition" error.

What am i missing here?

Thanks

Edited by: ramaks on Dec 30, 2009 7:00 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 04, 2010 at 05:35 AM

    Hi,

    Trry to define the filter key as:

    <FILTER KEY="@Select(Date.Year\Year)"><CONDITION OPERATORCONDITION="InList">
    <CONSTANT CAPTION="@Prompt('Calendar Year(s)','A','Date.Year\Year',multi,constrained)"/>
    </CONDITION></FILTER>
    

    Regards,

    Rohit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Didier,

      This is exactly the same way i have defined. not sure whats missing for the parse error to occur

      "<FILTER KEY="@Select(Date.Year\Year)

      "><CONDITION OPERATORCONDITION="InList"><CONSTANT CAPTION="@Prompt('Choose an Year','A','Date.Year\Year',multi,constrained)"> </CONSTANT> </CONDITION></FILTER>"