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

BI4 BICS Webi : Problem with Quarter Aggregation

Hello,

I'am using a BICS connection on a Query which use a user exit on the calendar year period.

To have the proper result in Webi i ticked the option :Use Selection of structure Element in the RSRT.

The period is now working properly but when i try to aggregate data in Webi on the Quarter the data could not be refreshed.

I have then desactivate the merging of dimension, overall result is ok by quarter but quick filter does not work anymore.

Thanks for your help

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 01, 2012 at 04:58 PM

    Hi,

    when you use the BICS connection then the measures from Web Intelligence will be set to database delegated aggregation, means that Web Intelligence will ask BW for the aggregated values.

    does you BEx query have a dimension for the quarter ?

    Ingo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ingo Hilgefort

      Hi Ingo,

      I am facing issue with Bex Key figures with exception aggregation 'maximum' not reflecting in BICS connection.

      Do you have any pointers, if this issue can be resolved?

      As if now, we decided to take a route of creating OLAP Universe to fix this problem.

      Regards

      Jitin

  • Posted on Jan 02, 2012 at 03:56 PM

    Which Drilling fuctionality are you using ? i mean query drill or standard drill.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I just add the quarter in Webi tab and i remove the period.

      When i have the data by quarter and i try to implement a quick filter cells could not be refreshed

      It seems that i have the problem with all the field gathered in the time dimension.

      Other fields are working properly

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.