BI4 BICS Webi : Problem with Quarter Aggregation

[Former Member]

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

[former_member666794]

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

[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

[IngoH]

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

[Former Member]

Hello Ingo,

The Quarter is in the "Time" Dimension, the same dimension than the Period.

When i check the Bex query i do not faced problem.

When i was using the Integration kit i needed to switch the measure to summaton instead of database delegated in the univers

but in the BICS nothing could be customized

Regards

[IngoH]

Hi,

the BICS connection does not allow you to customize the type of aggregation and therefore all measures are database delegated items.

ingo

[Former Member]

Hello Ingo,

I created support message and it seems that other people have the same problem

with the Bics Connection.

If no correction exist i will need to find a workaround using Webi Variable.

Regards

[IngoH]

Hi,

all the keyfigures in the BI4 system for Web Intelligence are database delegated, so when you change the aggregation level the system will have to ask BW again for the correct aggregated values.

all you do is refresh the report

ingo

[Former Member]

Hello Ingo.

Even after many refresh i see no result. The source query is using standard aggregation, whatever the level of

aggregation if i apply Quick Filter in Webi data is not refresh.

I will try to install latest patch 2.8

The BICS is based on 7.0 EHP1 latest SP

Regards

[IngoH]

Hi,

is the quarter a dimension from BW or formula you created ?

ingo

[Henry_Banks]

hi,

pls could you quote your OSS numbe? i'd like to consult with the engineer.

regards,

H

[Former Member]

Hello,

Message number is 1084822/2011;

You have attached description of the issue

https://websmp130.sap-ag.de/sap(bD1mciZjPTAwMQ==)/bc/bsp/spn/smp_custmsg/main.do?event=LOAD&pointer=...

Regards,

[Henry_Banks]

Hi V,

I recommend you open the Service Connections to your BW SID. Our support engineer can connect remotely and reproduce against your data.

R/3 Support - Note 812732

BW RFC Connection - Note 195715

BW GUI Connection - Note 195715

I will ping my colleague (i.e. support engineer assigned)

Regards,

H

[MariannevL]

Hi,

Just a little extra information on the topic of database delegation for measures in BICS...

In FP 2.3 the aggregation method of measures with standard aggregation will be set to sum() and not database delegated anymore, this will help solve a lot of these issues.

Off course for real 'smart measures' like ratio's and count distincts, you will still have database delegated,

as they have to be calculated by the database on each datapoint in the report.

Good luck,

Marianne

[IngoH]

Hello Vierm01,

in case the Quarter is not part of the list of available dimensions then BW will not be able to create the aggregation and you keyfigures are configured to be database delegated.

Ingo

[IngoH]

HI Marianne,

first of all patch 2.3 is already release a long time and does not change the behavior at all. if at all then the behavior will change with an upcoming release

regards

Ingo Hilgefort

[Former Member]

Hello,

We will patch our system to 2.10 and test again.

Regards

[Former Member]

Hello,

The Quarter is part of the Standard time dimension

Regards

[IngoH]

Hi,

then you should be able to include the Quarter into the underlying BEx Query and into the Web INtelligence report, which then will also give you the aggregated values for the Quarter in Web Intelligence

ingo

[Former Member]

Hello,

After implementation of the latest package. BICS is working properly

Regards

[Former Member]

What patch #?

[Henry_Banks]

Patch2.12 is the latest one , and the only one available to download.

Patch2.13 is coming soon. As is Ramp Up for FP03.

Regards,

H

[MariannevL]

Hi Igno,

It's FP 2.3 that I was talking about, not fp 2.3.

FP 2.3 is Feature Pack 2.3 which will start ramp-up soon.

Thanks,
Marianne

[Former Member]

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