Planning Analytics

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------

#PlanningAnalyticswithWatson

Hello,

Within your process, on the data tab you can set a condition : 
if( vproduct@='200')
CellputN(XXX,Cube, Dim1,Dim2...)
Endif;

NB : you can also set vproduct as a parameter to make the import dynamic and let user set the value for vproduct

Regards,

------------------------------
Florence Mougnaud
------------------------------

Original Message:
Sent: Tue November 26, 2019 09:31 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------

#PlanningAnalyticswithWatson

Hello,

OR you can use 

if( vproduct@<>'200')
  ItemSkip;
Endif;

# your business logic
#CellputN(XXX,Cube, Dim1,Dim2...) ​​

------------------------------
G PF
------------------------------

Original Message:
Sent: Tue November 26, 2019 09:31 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------

#PlanningAnalyticswithWatson

Hi,

Thanks for your reply. Noticed we couldnt delete the pre-generated script in the data tab. If I would to apply the checking  before the CellPut(), how should I do it? 

#****Begin: Generated Statements***
vProd=subst(Productcode,1,3);
vYear=FormatDate(ParseDate(Period,'dd/MM/yyyy'),'YYYY');
CellPutN(CellGetN('meExp',vProd,vYear)+Sales,'meExp',vAcc,vYear);
#****End: Generated Statements****

Newbie,
Ida

------------------------------
ida lasim
------------------------------

Original Message:
Sent: Wed November 27, 2019 08:28 PM
From: G PF
Subject: load data into Planning Analytics with filters/condition

Hello,

OR you can use 

if( vproduct@<>'200')
  ItemSkip;
Endif;

# your business logic
#CellputN(XXX,Cube, Dim1,Dim2...) ​​

------------------------------
G PF

Original Message:
Sent: Tue November 26, 2019 09:31 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------

#PlanningAnalyticswithWatson

Hi Ida, 

you should set the "contents" in variables tab as "other" and do the coding manually. 



------------------------------
Veronika Gultom
------------------------------

Original Message:
Sent: Thu November 28, 2019 08:47 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi,

Thanks for your reply. Noticed we couldnt delete the pre-generated script in the data tab. If I would to apply the checking  before the CellPut(), how should I do it? 

#****Begin: Generated Statements***
vProd=subst(Productcode,1,3);
vYear=FormatDate(ParseDate(Period,'dd/MM/yyyy'),'YYYY');
CellPutN(CellGetN('meExp',vProd,vYear)+Sales,'meExp',vAcc,vYear);
#****End: Generated Statements****

Newbie,
Ida

------------------------------
ida lasim

Original Message:
Sent: Wed November 27, 2019 08:28 PM
From: G PF
Subject: load data into Planning Analytics with filters/condition

Hello,

OR you can use 

if( vproduct@<>'200')
  ItemSkip;
Endif;

# your business logic
#CellputN(XXX,Cube, Dim1,Dim2...) ​​

------------------------------
G PF

Original Message:
Sent: Tue November 26, 2019 09:31 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------

#PlanningAnalyticswithWatson

Hi,

you can also include your condition before the generated statement like this : 

vProd=subst(Productcode,1,3);
if(….);
#****Begin: Generated Statements***
vProd=subst(Productcode,1,3);
vYear=FormatDate(ParseDate(Period,'dd/MM/yyyy'),'YYYY');
CellPutN(CellGetN('meExp',vProd,vYear)+Sales,'meExp',vAcc,vYear);
#****End: Generated Statements****
Endif;

Regards,

------------------------------
Florence Mougnaud
------------------------------

Original Message:
Sent: Fri November 29, 2019 08:56 AM
From: Veronika Gultom
Subject: load data into Planning Analytics with filters/condition

Hi Ida, 

you should set the "contents" in variables tab as "other" and do the coding manually. 

put the code to filter and to cellputn in data tabs as per your requirement. 

Regards
Veronika

------------------------------
Veronika Gultom

Original Message:
Sent: Thu November 28, 2019 08:47 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi,

Thanks for your reply. Noticed we couldnt delete the pre-generated script in the data tab. If I would to apply the checking  before the CellPut(), how should I do it? 

#****Begin: Generated Statements***
vProd=subst(Productcode,1,3);
vYear=FormatDate(ParseDate(Period,'dd/MM/yyyy'),'YYYY');
CellPutN(CellGetN('meExp',vProd,vYear)+Sales,'meExp',vAcc,vYear);
#****End: Generated Statements****

Newbie,
Ida

------------------------------
ida lasim

Original Message:
Sent: Wed November 27, 2019 08:28 PM
From: G PF
Subject: load data into Planning Analytics with filters/condition

Hello,

OR you can use 

if( vproduct@<>'200')
  ItemSkip;
Endif;

# your business logic
#CellputN(XXX,Cube, Dim1,Dim2...) ​​

------------------------------
G PF

Original Message:
Sent: Tue November 26, 2019 09:31 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------
#PlanningAnalyticswithWatson

Hi Ida, 

just to be more clear:

1. Set all the variables to "other" 
2. go to data tabs
3. Put your code as per requirement
    ex: 
     vProd=subst(Productcode,1,3);
     if (vProd@='200');        # or use parameter as Florence wrote
         vYear=FormatDate(ParseDate(Period,'dd/MM/yyyy'),'YYYY');
         CellPutN(CellGetN('meExp',vProd,vYear)+Sales,'meExp',vAcc,vYear);​
      else;
        ItemSkip;
    Endif;

   Regards,

------------------------------
Veronika Gultom
------------------------------

Original Message:
Sent: Fri November 29, 2019 08:56 AM
From: Veronika Gultom
Subject: load data into Planning Analytics with filters/condition

Hi Ida, 

you should set the "contents" in variables tab as "other" and do the coding manually. 

put the code to filter and to cellputn in data tabs as per your requirement. 

Regards
Veronika

------------------------------
Veronika Gultom

Original Message:
Sent: Thu November 28, 2019 08:47 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi,

Thanks for your reply. Noticed we couldnt delete the pre-generated script in the data tab. If I would to apply the checking  before the CellPut(), how should I do it? 

#****Begin: Generated Statements***
vProd=subst(Productcode,1,3);
vYear=FormatDate(ParseDate(Period,'dd/MM/yyyy'),'YYYY');
CellPutN(CellGetN('meExp',vProd,vYear)+Sales,'meExp',vAcc,vYear);
#****End: Generated Statements****

Newbie,
Ida

------------------------------
ida lasim

Original Message:
Sent: Wed November 27, 2019 08:28 PM
From: G PF
Subject: load data into Planning Analytics with filters/condition

Hello,

OR you can use 

if( vproduct@<>'200')
  ItemSkip;
Endif;

# your business logic
#CellputN(XXX,Cube, Dim1,Dim2...) ​​

------------------------------
G PF

Original Message:
Sent: Tue November 26, 2019 09:31 PM
From: ida lasim
Subject: load data into Planning Analytics with filters/condition

Hi all,

I have 300k records from a csv file to load using TI. If I wanted to put a filter only to load records which met the condition from Variable created in TI, how should I do it? 

1. Using Rules in Cube or
2. Add-in filter somewhere in TI itself?

i.e VProduct =subst(Productcode,1,3);
Only to load VProduct = '200'

Can someone pls assist. TQ ;)

------------------------------
ida lasim
------------------------------

#PlanningAnalyticswithWatson