Skip to Content
author's profile photo Former Member
Former Member

Pboblem with 0infoprov in filter characteristics

Hi Experts,

In our proj,we are doing logical partitioning based on multiprovider.

As we had a large cube with many millions of data ,we decided to

divide it into smaller cubes based on the year.

Till modeling there is no problem.In Bex reporting,

while restricting the cubes based on year,we got struck.

Can any one guide me through this ?

Also I think we can also do the work of 0infoprov using constants.

Can any body please explain me?

Smiles,

Sundar

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2011 at 07:58 AM

    Hi Sundar,

    Please refer the document given in the below link.

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/751be690-0201-0010-5e80-f4f92fb4e4ab

    What is the selection conditions in your report? If you have year as one of the mandatory selection conditions, you can use that to derive values for 0INFOPROV or else if you have any other time chars you can use that to derive 0INFOPROV, in the cmod exit.

    Please bear in mind that even if you do not specify any filter on 0INFOPROV, your query would work. Only benefit of having filter on 0INFOPROV is enhanced performance.

    Thanks,

    Krishnan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sundar,

      If you use constants on 0InfoProvider then you will have to restrict it with all the years if you don't know from which year the data will be accessed.

      As it will be same with and without restriction, so as to get the performance benefit of logical partitioning you will have to restrict 0InfoProv using dynamic values. e.g. by determining values using customer exit variable.

      Regards,

      Durgesh.

  • Posted on Jul 17, 2011 at 07:44 AM

    Hi,

    If you want to restrict any particular Infoprovider under Multiprovider, you can use 0infoprovider from data packet dimension in Filter section of the Query Designer.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 17, 2011 at 10:54 AM

    Hi

    as in your case u say u have only infocubes in your multi provider

    you can Maintain tableu201CRRKMULTIPROVHINTu201C with the partitioning criteria 0CALMONTH and MultiProvider name.

    In the RRKMULTIPROVHINT table, you can specify the MultiProvider and a characteristic for partitioning and if a query has restrictions on this characteristic, the OLAP processor will check which InfoCubes can return data for the query. The data

    manager can then completely ignore the remaining InfoCubes. This is handled by the OLAP processor.

    The system is doing a quick read of the dimension table of the InfoCube to check if the selected value (or multiple values!) are included and it's "worth" reading the full InfoCube.

    or else we can handle this through Customer exits.

    Let me know if this is helpful to you

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Krishna,

      what is the difference between RRKMULTIPROVHINT and 0INFOPROV

      in RRKMULTIPROVHINT method ,first we specify the multi prov name and

      partitioning criterial like 0CALMONTH and in the query designer ,on the

      characteristic 0CALMONTH ,we will restrict accordingly. Am I right?

      Please correct me if I was wrong.

      Also in 0INFOPROV ,can't we do with out using customer exits.

      Userexit/default variable option is also there.how to use this.

      Please respond me .

      Thanks,

      Sundar

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.