TM1 Forum

I have 2 cubes with different dimensionality. Both of tchem include „Client” dimension but with another granularity. In „Cube 1” there is dimension „Client”. Dim_Client.PNG „Cube 2” has „Client_N” dimension. Dim_Client_N.PNG I would like to copy data from cube 1 to cube 2. How should be such procces...

Mark RMBC, gtonkin,

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

Thanks.

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

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

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] ,[ZZP...

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

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.

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