cancel
Showing results for 
Search instead for 
Did you mean: 

FORMAT to increase column width and Nested IF

Former Member
0 Kudos

Hi

I Have two questions

1. I'm extracting data from BI to BPC with if condition as if material type = HAWA get one list, else if mattype = FERT get other list, else if anyone blank then add NONE

SALESMATRIX = *IF (0MATERIAL__0MATL_TYPE = *STR(HAWA) THEN  0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0MATERIAL__0MATL_TYPE=*STR(FERT) THEN 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0SALESEMPLY=*STR() THEN *STR(NONE); 0DISTR_CHAN=*STR() THEN *STR(NONE))

is this formula correct, because my package get failed by giving blank member to SALESMATRIX.

Can anyone please let me know how can I write IF...ELSE statements in Transformation file.

2. I'm trying to increase column width for my LOCAL Member Formula, but after refreshing again it is not increasing and value not able to see, it will be in #####.

Can anyone please let me know how can I increase my column width for total

Regards

Silu

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

Hi Silu,

For the first question - start with simple *IF and continue...

For the second - if you have enabled "Auto Fit Column Width" in Sheet Options - then your local members will fit!

Vadim

Former Member
0 Kudos

Hi

I already enabled 'Autofit column width' but still it is not increasing my local member formula column.

in same template my EPMolap memer formula not allowing me to select values, it is displaying as formula when I double click.

I unprotected sheet, but still it is showing as formula, and my edit report also in disable mode, I protected sheet using "sheet options->protect"

= EPMOlapMemberO("[CATEGORY].[PARENTH1].[BUDGET]","","BUDGET","","000")

Regards

Silu

former_member186338
Active Contributor
0 Kudos

Sorry, but absolutely not clear...  Without screenshots!

Are you talking about "EPMOlapMemberO" in page axis???

Vadim

Former Member
0 Kudos

Hi

I wrote my *IF condition as given below

SALESMATRIX = *IF (0PROFIT_CTR=*STR(CCP) THEN 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN;

0MATERIAL__0MATL_TYPE = *STR(HAWA) THEN  0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN+0PRODH4; 0CUSTOMER__0COUNTRY = *STR() THEN *STR(NONE); 0SALESEMPLY=*STR() THEN *STR(NONE); 0DISTR_CHAN=*STR() THEN *STR(NONE))

but load got failed whether my logic is correct, how *IF ELSE IF works in transformation file with out ELSE condition, during true or false conditions which value will it take, because all are separated with ';' (semicolon), I didn't understand how *IF ELSE works in Transformation file

Regards

Silu

former_member186338
Active Contributor
0 Kudos

Simple formula???

Former Member
0 Kudos

Hi

I attached screen shot, Edit report also not working for me, no password also.

Regards

Silu

former_member186338
Active Contributor
0 Kudos

Sorry, but have you checked the Microsoft security updates resulting in corrupted behavior of EPM?

Vadim

Former Member
0 Kudos

Hi Klien,

1)

= EPMOlapMemberO("[CATEGORY].[PARENTH1].[BUDGET]","","BUDGET","","000")



Please check some options, go to options then select "User Options" select Navigation tab and mark "Enable Double Click". .

For Edit report greyed Out

Also might be issue of the windows automatic update. Please look at below thread.

Regards,

Sushant

Former Member
0 Kudos

Hi Klien,

For the edit report greyed out also look at below threads,

Regards,

Sushant

Former Member
0 Kudos

Hi Vadim

I didn't understand "simple formula???",

my logic is as given below and I'm not sure how IF ELSE works in BPC as we are giving only ";" to separate each condition

SALESMATRIX = *IF (0PROFIT_CTR=*STR(CCP) THEN 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0MATERIAL__0MATL_TYPE = *STR(HAWA) THEN  0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN; 0CUSTOMER__0COUNTRY+0SALESEMPLY+ 0DISTR_CHAN+0PRODH4; 0CUSTOMER__0COUNTRY = *STR() THEN *STR(NONE); 0SALESEMPLY=*STR() THEN *STR(NONE); 0DISTR_CHAN=*STR() THEN *STR(NONE))

Regards Silu

Former Member
0 Kudos

Hi Sushant

Thank you, yes some windows patches has been updated due to this reason, server got down and edit report also greyed out, now EPM edit report and formulas working fine.

Regards

Silu

former_member186338
Active Contributor
0 Kudos

Start with less conditions and ensure it's working, then try to extend...

Former Member
0 Kudos

Hi Vadim

Thank you, now my IF condition formula working fine

Regards

Sreevani

Former Member
0 Kudos

Hi

to add one more point for Transformation file formula

if Profit Center = CCP then irrespective of material type get one value

if profit center <> CCP and mattype = HAWA then bring one value from BI

if Proft center <> CCP and mattype <> HAWA then bring another value from BI

so how can I go ahead for this IF condition in transformation file

Regards

Silu