Search found 5 matches

by djarko
Thu Apr 18, 2019 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading MTD data as YTD data
Replies: 8
Views: 292

Re: Loading MTD data as YTD data

Hi Wim, I manipulated with SQL code, and, I think reached my target: on Maps\Cube tab "Data Action" field I set as "Store values". In Sql code I used MAX(MONAT) instruction, so Advanced\Prolog tab looks like: DataSourceQuery = 'SELECT [GJAHR] ,max([MONAT]) ,[LDGRP] ,[HKONT] ,[ZZPRODUCT] ,[ZZDISTCHAN...
by djarko
Wed Apr 17, 2019 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading MTD data as YTD data
Replies: 8
Views: 292

Re: Loading MTD data as YTD data

Isn't there posibility to manipulate with month dimension on Variables tab? I would like to use, as viariable, P_Month parameter, instead of dimension from SAP table (see attachment). Variables.PNG what do you mea: Load YTD values (Jan, Feb, Mar, Apr) cumulatively into the month of April This is wha...
by djarko
Wed Apr 17, 2019 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading MTD data as YTD data
Replies: 8
Views: 292

Re: Loading MTD data as YTD data

B.MIESIAC.jpg
B.MIESIAC.jpg (104.95 KiB) Viewed 275 times
by djarko
Wed Apr 17, 2019 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading MTD data as YTD data
Replies: 8
Views: 292

Re: Loading MTD data as YTD data

But my YTD loading is intentional. I want to avoid situation, when I closed month in TM1, but in SAP where booked some i.e. invoices.
Those invoices I want to include in managerial reporting in next Period.
by djarko
Wed Apr 17, 2019 1:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading MTD data as YTD data
Replies: 8
Views: 292

Loading MTD data as YTD data

Hi, I'm newbie in developing TM1. I have such issue - in ODBC Source (SAP) I have transactional data from General Ledger with some dimensions (Line of Business, Distribution Channel...). I would like to load aggregated data (not transactional) into TM1 cube but into dimension 'Interval' = YTD I wrot...