About former_member559998

former_member559998 · 06-06-2018

Hello All, As I was exploring for a need to get begin and end dates, I happened to stumble across blog, which gives information on how to derive begin & end dates of current & next quarters; based on learning from this blog, I thought of deriving th...

former_member559998 · 08-13-2012

Hi All,We are facing a strange problem, when using BEx queries, where we do not have option to exclude values in global filter of any query in our system (selection screen pop up). There is no option to exclude both in context menu (right click) and ...

former_member559998 · 05-09-2012

Hi Everyone,I would like to know about non-cumulative key figures. I have read about it, still is not completely clear. I would like to know following about them1. Why are they used?2. What are the advantages of these key figures?3. When using these ...

former_member559998 · 02-16-2012

Hi All,I have been reading BWA and its underlying concepts for faster data retrieval. I have gone through following:Vertical data compression (columnar storage)Horizontal data partitioningIn memory computingBIA indicesI am not clear with following an...

former_member559998 · 01-11-2012

Hi All,I am working on query performance optimization analysis, I have a scenario where a multiprovider has predominantly infocube and just 4 DSOs. These 4 DSOs are flat-file loads and are directly used for reporting.We have applied Multiprovider hin...

former_member559998 · 02-26-2018

Hello, If you are still looking for finding out the models that are restricted in an Analytical Privilege, please try table _SYS_REPO"."ACTIVE_OBJECTCROSSREF"; give AP details in FROM_ fields and you can get underlying objects in TO_ fields. In c...

former_member559998 · 08-14-2012

Hi KRPK,Thanks for your response. Your links provided me good information. We are not using any webreports and on analysis, I have identified that for variables with type 'Multiple Single Values', there is no option to exclude where as selection opti...

former_member559998 · 03-20-2012

Hi Pierre,I have tried your scenario using following option and it worked for me:Aggregation: SUMException Aggregat.: Average (All Values)Agg.referen.char. 0CALDAY Please check.Thanks and regards,Shashidhar.

former_member559998 · 03-19-2012

Hi,Could you please update, if the option suggestion by Deb is the correct solution.Thanks and regards,Shashidhar.

former_member559998 · 02-22-2012

Hi Wout,Is it any invalid character issue? When you are executing manually, are you simply executing it or making any corrections to data?Thanks and regards,Shashidhar.

User Statistics

User Activity

Get last, current & next quarters' begin and end dates without conditional checks

BEx query selection pop up does not allow to exclude values in any filter criteria

Non cumulative key figures in SAP BW

Understanding BWA - indices saving and usage

DSO vs. Infocube - modeling criterion

Re: HANA Security tables

Re: BEx query selection pop up does not allow to exclude values in any filter criteria

Re: How to create an average Key figure in SAP BI 7 correctly

Re: DTP process won't finish

Re: 7.0 MD Process Chain fails - individual InfoPackages run fine manually