Can we include ALL in a Prompt's syntax of OLAP UNIVERSE

[Former Member]

Hi,

We have a OLAP universe based on a cube generated from Analysis services.

We have desidned a condition object in which we have added a prompt which works fine. Can we add more functionality to this prompt where we can include "ALL".

I know that there is optional prompts but i still need this functionality as i shall pass some value when i am binding my xcelsius components to this prompts.

Thanks

J

[Former Member · Accepted solution]

Jithendra,

You can build an optional predefined filter that mix "All" level with other levels with OR operator.

In that case you will be able to select "All" or any other value coming from another level.

Here is a sample based on AdventureWorks where I used "Product Categories" hierarchy and a "Like" operator.

<OPERATOR VALUE="OR" >
    <OPTIONAL>
        <FILTER KEY="[Product].[Product Categories].[(All)]" >
            <CONDITION OPERATORCONDITION="Like" >
                <CONSTANT CAPTION="@prompt('Products','A','Product Categories\(All)',Mono,Free,Persistent)" />
            </CONDITION>
        </FILTER>
    </OPTIONAL>
    <OPTIONAL>
        <FILTER KEY="[Product].[Product Categories].[Category]" >
            <CONDITION OPERATORCONDITION="Like" >
                <CONSTANT CAPTION="@prompt('Products','A','Product Categories\Category',Mono,Free,Persistent)" />
            </CONDITION>
        </FILTER>
    </OPTIONAL>
    <OPTIONAL>
        <FILTER KEY="[Product].[Product Categories].[Subcategory]" >
            <CONDITION OPERATORCONDITION="Like" >
                <CONSTANT CAPTION="@prompt('Products','A','Product Categories\Subcategory',Mono,Free,Persistent)" />
            </CONDITION>
        </FILTER>
    </OPTIONAL>
</OPERATOR>

Didier