About adam_rench2

adam_rench2

Hi all, I'm trying to get an average of a set of monthly values. However the monthly values are also a calculated field that I need to get a count of unique Unit Numbers per month but then average that value by month. NOTE: I am using SAP BW query ...

adam_rench2

Hello all, Hoping for some help here. I'm somewhat new to Webi but very experienced in BW. I had created a query in BW that used Exception Aggregation but Webi didn't like that and I wasn't able to apply certain input controls without the dreaded ...

adam_rench2

I have a BW query via BICS into my webi report. I have built variables around my delegated key figures using a =SUM(MY BW DEL KF) and have used those variables in my report. I have three input controls, PLANT, DIVISION, and REGION. When I use my inpu...

adam_rench2

Hello all, I'm a BW developer and can currently open Analysis for Office and can search for and report directly on a Composite Provider. Example: ZV_COMP1 and let's say there's a query ZV_COMP1_Q0001 written on that Composite Provider as well. When...

adam_rench2

I have a table in webi. I have one BICS BW query as my Data Source. I have added an input control to filter on attributes of profit center. I have detailed records coming in at the profit center level. Then I have a total box on the top which I ha...

adam_rench2

FYI - I was able to figure it out but wanted to document how I did it in case others need this same info:I ended creating a variable with this and also I wanted a whole number so I used the round function to zero.=Round(Average (Count ([Unit Number];...

adam_rench2

I was able to figure it out. SUM (COUNT ([# of Contracts] In ([Part #];[Calendar Year/Week])))

adam_rench2

Sorry - This helped but not 100% yet. I have two measures that I want to take into consideration here. # of Contracts and Sales $ now. I still want to get the unique # of parts for each of those measures for each week.How would I add the measure i...

adam_rench2

Kiran - my users have the ability to report on Classic DSOs and InfoCubes but not ADSOs and Composite Providers. Any ideas why?

adam_rench2

I'm also interested in this topic. My users can report directly on classic InfoProviders but not Composite Providers and I can't seem to figure out what auth object it's tied to. They have full display in S_RS_COMP.

User Statistics

User Activity

How to Average a sum of distinct values in Webi

Count of unique values for a specific measure using Webi

#TOREFRESH BICS Query with Exception Aggregation & Input Controls

Security to report directly on Composite Provider via Analysis for Office

How to prevent #MULTIVALUE from appearing in total box in Webi when filtering using Input Controls

Re: How to Average a sum of distinct values in Webi

Re: Count of unique values for a specific measure using Webi

Re: Count of unique values for a specific measure using Webi

Re: Reporting directly on info provider (without a query) with analysis for office

Re: Reporting directly on info provider (without a query) with analysis for office