List of Contributions

ida lasim

Contact Details

My Content

1 to 10 of 10 total

Overfeeding Feeders?

Posted By ida lasim Tue June 14, 2022 03:03 AM
Found In Egroup: Planning Analytics \ view thread
Hi All, I am feeding Forecast Summary cube from Forecast Detail cube. looking at my feeders, I just worried that I might overfeeding. I have 12 products which mapped to 5 major products. Is it correct to do this way or any better way to link between these 2 cubes? Am I overfeeding with this statement? ...

Consolidated Value

Posted By ida lasim Wed February 23, 2022 10:53 PM
Found In Egroup: Planning Analytics \ view thread
Hi All, Can someone please help me with the rules? my TestUPR cube doesnt get the correct Total FYE (consolidated value). Tried with simple cube TestComm which works fine. May I know what's wrong with my rules? Thank you in advance! regards Ida ------------------------------ ida ...

Feeders

Posted By ida lasim Wed February 16, 2022 12:06 PM
Found In Egroup: Planning Analytics \ view thread
Hi Everyone, Just trying to get my understanding correct on Feeders. Based on Planning Sample Cube, I am looking at plan_BudgetPlan rules. skipcheck; ['local','line input']=DB('plan_BudgetPlanLineItem', !plan_version,!plan_business_unit,!plan_department, !plan_chart_o ...

RE: Load Data to Consolidated element in TI

Posted By ida lasim Tue December 21, 2021 04:18 AM
Found In Egroup: Planning Analytics \ view thread
HI Cécile, Thanks for your reply. However, I wanted to load 56k lines into the cube with Amount column mapped to Total which later to be spread. Thanks! ------------------------------ ida lasim ------------------------------

Load Data to Consolidated element in TI

Posted By ida lasim Mon December 20, 2021 09:12 PM
Found In Egroup: Planning Analytics \ view thread
Hi All, Is it possible to load data at consolidated element? Tried with Xmonth = 'Total' but it prompt error consolidated type. When I changed XMonth = 'Jan' it loaded successfully to Jan. In my case I wanted to load Amount to "Total" which refers to (Jan-Dec). Understood that additional code ...

Dimension create in PAW cannot upload

Posted By ida lasim Tue March 10, 2020 10:56 PM
Found In Library: Planning Analytics
#PlanningAnalyticswithWatson

Dimension create in PAW cannot upload

Posted By ida lasim Tue March 10, 2020 10:56 PM
Found In Egroup: Planning Analytics \ view thread
Hi all, I'm exploring PAW to create dimension using drop csv option. However when upload I got this prompt error. Kindly please help :) ------------------------------ ida lasim ------------------------------ #PlanningAnalyticswithWatson

Turbo Integrator - Read multiple file at once

Posted By ida lasim Wed January 15, 2020 03:55 AM
Found In Egroup: Planning Analytics \ view thread
Hi all, Is it possible to read multiple files at once when using turbo integrator for cube update. I have 24 csv files differentiate by filename source_yyyymm.csv (source_201901.csv, source_201902.csv, etc..). Some solutions I found while browsing is create 24 TI process or using paw. However I prefer ...

RE: load data into Planning Analytics with filters/condition

Posted By ida lasim Thu November 28, 2019 08:47 PM
Found In Egroup: Planning Analytics \ view thread
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'); ...

load data into Planning Analytics with filters/condition

Posted By ida lasim Wed November 27, 2019 09:09 AM
Found In Egroup: Planning Analytics \ view thread
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); ...