Filters in OLAP

Question

Hi,

I have created an OLAP cube but it is taking more time to load as there is more data, so i want to add a default date filter to it so that it may filter some data and loads fast.Could anyone helps how to add default date filters(analytical drivers) to OLAP.

Thanks in Advance.

Answer 1

Hi, with the OLAP designer you can connect parameters to Olap Document. To do that you should:

1) create an analytical driver in document details and save

2) open designer for OLAP document

3) create olap document with interface

4) open a filter clicking on funnel (the dimension on top)

5) there you can link the parameter to the level you want to filter 

6) save template

That's it.

Comments

Here an example of template with parameters

<?xml version="1.0" encoding="UTF-8"?>
<olap>
    <cube reference="templateWhatif"/>
    <MDXMondrianQuery>     SELECT         {[Measures].[Dist. products]}              ON COLUMNS,             {([Product])}                  ON ROWS          FROM             [Sales]          WHERE             [Customers].[Canada]</MDXMondrianQuery>

    <MDXQUERY>     SELECT         {[Measures].[Dist. products]}              ON COLUMNS,             {([Product])}                  ON ROWS          FROM             [Sales]          WHERE             [Customers].[${xxx}]<parameter
            as="xxx" name="xxx"/>
    </MDXQUERY>
    <JSONTEMPLATE>{"olap":{"cube":{"reference":"templateWhatif"},"MDXMondrianQuery":{"XML_TAG_TEXT_CONTENT":"     SELECT         {[Measures].[Dist. products]}              ON COLUMNS,             {([Product])}                  ON ROWS          FROM             [Sales]          WHERE             [Customers].[Canada]"},"MDXQUERY":{"XML_TAG_TEXT_CONTENT":"     SELECT         {[Measures].[Dist. products]}              ON COLUMNS,             {([Product])}                  ON ROWS          FROM             [Sales]          WHERE             [Customers].[${xxx}]","parameter":[{"name":"xxx","as":"xxx"}]}}}</JSONTEMPLATE>
</olap>