Search found 8 matches

by djarko
Wed Feb 19, 2020 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query - ODBC or syntax issue?
Replies: 5
Views: 399

Re: SQL Query - ODBC or syntax issue?

Mark RMBC, gtonkin,

You're completely right. There where white scpaces etc.

Thanks.
by djarko
Wed Feb 19, 2020 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query - ODBC or syntax issue?
Replies: 5
Views: 399

Re: SQL Query - ODBC or syntax issue?

Looking at the error I would check your spacing, for example you have sum([DMBTR]) as AmountFROM [SAP_Eksport].[dbo].[VE_Z_XTRACT_DOCUMENTS] ZapisySapLEFT There needs to be a space between Amount and From and ZapisySap and Left There are other spacing issues so I would sort that out first regards, ...
by djarko
Wed Feb 19, 2020 1:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query - ODBC or syntax issue?
Replies: 5
Views: 399

SQL Query - ODBC or syntax issue?

Hi, I have problem with TI process retrieving data from MS SQL Server database. Through couple month I had properly working process. There where Datasource query: SELECT [GJAHR] ,[MONAT] ,[LDGRP] ,[HKONT] ,[ZZPRODUCT] ,[ZZDISTCHAN] ,[ZZACCIDENT] ,[ZZSOURCE] ,[ZZACTIVITY] ,[ZZREINSCON] ,[ZZIP] ,sum([...
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: 984

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: 984

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: 984

Re: Loading MTD data as YTD data

B.MIESIAC.jpg
B.MIESIAC.jpg (104.95 KiB) Viewed 967 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: 984

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: 984

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...