About former_member211767

former_member211767 · 02-27-2018

Hi I want to see the values populated that are lower than 2 decimal places that lumira brings in percentages-lumira.jpgpercentages-excel.jpg As you can see from the two attachments. The values comes as 0.00 when there is a value in excel . ...

former_member211767 · 10-31-2017

I am using FUNCTION CC_TOTAL_YEAR to extract the total value of a Fund Center for the year 2015. Which will be later used for other calculations for now I just want to know if what I am doing is correct or is there another way of doing this in scr...

former_member211767 · 10-24-2017

Hi All I am new to BPC and very limited knowledge of logic scripts I have the following requirement: "Distribute Forecast from year to Months based on recent 3 year monthly average based on cost center" From a logic standpoint I think I have ...

former_member211767 · 08-15-2016

Hello ExpertsCan you please tell me if where am I going wrong or a better way to get results. I tried decode however it went to the level 3 all the time even though there are instances in level 1IFTHENELSE(QryFinalLookup.MEM_LEVEL0_SHORT iS NULL, IFT...

former_member211767 · 06-23-2015

HiI am trying to get the YTD working on a query. This is based on the payroll standard cube 0PY_C02.I am getting amounts for all periods however the YTD values are not being calculated and i am getting null values.Based on the following articleI trie...

former_member211767 · 02-14-2019

I was also getting the same error as before. Run it as Administrator. It worked

former_member211767 · 11-01-2017

When I validate the following code is coming up LGX: *XDIM_MEMBERSET FUND_CTR = 3371AA *XDIM_MEMBERSET DATASOURCE = BW,INPUT *XDIM_MEMBERSET PAA = BAS(ALL_BPC) *XDIM_MEMBERSET CMMT_ITEM <> CI_NA *XDIM_MEMBERSET SCENARIO = SC_0 *XDIM_MEMBERSET CAT...

former_member211767 · 11-01-2017

Hi Vadim Thanks for the tip. Will this run for all cc or the ones scoped? When running it in UJKT in simulation I am getting this error APPLICATION:RCN_HIGH_LEVEL [INFO] GET_DIM_LIST(): I_APPL_ID="RCN_HIGH_LEVEL", #dimensions=12 CATEGORY,CC_WB...

former_member211767 · 11-01-2017

Ok thanks

former_member211767 · 11-01-2017

Hi Vadim If I cannot store data in BPC script logic. How do i then tackle this problem? I need to calculate the weighted avg rate for every month and then allocate it to all cost center for the current forecast year. business logic has it that ja...

User Statistics

User Activity

How to show percentages or load percentage in Lumira discovery

Using FUNCTION formula to retrieve Fund Center total value for the year

Forecast year into monthly by getting the 3 year monthly average BPC Logic Script

SAP BODS - NESTED IF STATEMENT

Bex Query YTD on FPPER not working

Re: Client Tools Install - At least one port in the range 4520-4539 must be open for the installation

Re: Using FUNCTION formula to retrieve Fund Center total value for the year

Re: Using FUNCTION formula to retrieve Fund Center total value for the year

Re: Using FUNCTION formula to retrieve Fund Center total value for the year

Re: Using FUNCTION formula to retrieve Fund Center total value for the year