on 12-29-2014 8:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.