Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

722 Topics
P
Visitor
Picanova BIVisitor
asked in Jobs & Executions
Transfer Error - Invalid column name - Incremental Execution MDW

Hello,one of several incremental tables won't execute. upon execution the transfer fails stating "invalid column name " & name of the incremental column.The problem occurred in Version 19.2.7.64 and is still present after an upgrade and redeployment to Version 19.11.7.64.What I tried so far. I tried to change the column from Incremntal_date to id.Redeployed the full table configuration.Upgraded to Version 19.11.7.64.Help is much appreciated. Best regardsPeter 

511
JTreadwell
Employee
D
Starter
dritzStarter
asked in Prepare
How can a parent-child hierarchy be historicized using parent DW_Ids?

How can a parent-child hierarchy be historicized using parent DW_Ids?

461
D
Starter
H
Contributor
hgrContributor
asked in Jobs & Executions
Manually reloading recent data

Just for anybody interested: I just found out that you just update the _I table to some older values, to reload all data greater than the value you set. Previously, I always reloaded the full table in these cases. This is not necessary and saves me some time from now on.

553
JTreadwell
Employee
S
Starter
stefan.timmermanStarter
asked in Ingest
csv filename changed after load

When I am using the Single text file and I am loading a csv file, TX replaces and removes the file to the Backup folder as specified. The filename before load:  E:\BAG\CoordinatenBAG2019.csv And the filename after loading:  E:\BAG\CoordinatenBAG2019__20191105_163142_ Now I have to rename the file every time i want to do a reload. How can I prevent this?  

172
S
Starter
H
Contributor
hgrContributor
asked in Jobs & Executions
Incremental Load not Delivering Data

Hello,I have the following setup for an incrementally loaded table:I would expect, that it loads all rows, with either an id greater than max id - 1000 or datum_post greater than max datum_post - one week.In fact, when I execute the query, it is not returning any rows. This is interesting, because removing the datum_post condition returns rows.Other tables with such a double condition (id + date) also work. I am wondering, whether it is necessary to have an index on datum_post in the source table? The queries can take quite a while on the datum_post field. The example query takes 2 minutes on the source database, but TimeXtender finishes after 30 seconds. TimeXtender says it is finished with "Success", but there are no rows.Also the following query yields results when querying the source database directly: I think this is the equivalent query to what TimeXtender should load.I am using Discovery Hub 19.6.7.64 and the source database is using (an old) mysql version: I am connecting with

801
H
Contributor
D
Contributor
dsvartzmanContributor
asked in Prepare
database diagram: visualize your data model

Hi, i've setup a MDW layer with proper relations between tables. At this point I wanted to create a relation diagriam to visualise to my client the relation between his entities. my tool of choice was SQL Management Studio. Only then i've realised that TimeXtender only create DW_Id as physical primary key and the relations between tables are managed internally Is there a way in TimeXtender to visualize the relations between the tables? I've already put my vote here  

836
D
Contributor
R
Starter
r.brummansStarter
asked in Ingest
Delete data due to privacy legislation

We want to delete the data in TimeXtender after a period of 5 years because of the GDPR legislation . Is there a possibility to get this handled by TimeXtender?

161
JTreadwell
Employee
R
Contributor
rluytenContributor
asked in Jobs & Executions
Execution blocking access to cubes

Hello, Since a couple of days I created a second execution package to execute +- 10 tables, some dimension and 1 cube. After this execution the other cubes are not reachable, I need to deploy and execute them all to get it solved. Any clue why an execution pack would block access ? Thanks, Ronny

233
E
Contributor
J
Starter
jose.hoyosStarter
asked in Prepare
Many to many Relations and conditional joins

Hi,I am trying to build a transformation process in TX based on the following SQL code.------------------------------------------SELECT distinct[BusinessEntityID],B.MonthKey,[StartDate],[EndDate],[DepartmentName]FROM [TX_DSA].[dbo].[EmployeeDepartmentHistory] Ajoin dbo.Calendar B ON B.Date >= A.StartDatewhere b.DateValue >= a.StartDate AND (a.EndDate is null or a.EndDate <= b.DateValue)----------------------------------------------------I want intentionally to expand the grain of table A. I tried different Joins and conditional lookups but I just can't reproduce the output.How would you solve this?Thanks in advancegrJose

543
J
Starter
S
Starter
sbanerjee1Starter
asked in Prepare
Using Collate on Join conditions

I am joining 2 tables T1 and T2 based on a condition T1.A = T2.BT1.A have values like 'wNFq' and T2.B have values like 'WNFQ', 'wnfQ', 'WnFq', 'wNFq'For a regular join a particular row of 'wNFq' from T1 gets joined with all values: 'WNFQ', 'wnfQ','WnFq' and 'wNFq' of T2My intention is to join only 'wNFq' from T1 to 'wNFq'.I achieved the same using custom SQL insert and using the below  COLLATE function to join based on case sensitive sequencing using:T1.A COLLATE Latin1_General_CS_AS_KS_WS = T2.B COLLATE Latin_1_General_CS_AS_KS_WSWandering if there is a different way to achieve this avoiding custom SQL.Appreciate any help on the same. 

934
S
Starter
S
Starter
sbanerjee1Starter
asked in Prepare
Filtering on the Look up fields

Created a conditional lookup based on following : T1 joined to T2 where T1.A = T2.B Looked up T2.C based on the above join condition and stored the value in T1.D Now I need to filter the resultant data set which is on T1 based on certain values of T1.D Unable to put that filter in the Table Data Selection Rule. Even I tried to copy T1.D(look up filed) to T1.E (a separate filed created just to hold the value of T1.D) and filter on T1.E, even that did not work. Appreciate help on the same.

1184
JTreadwell
Employee
H
Contributor
hgrContributor
asked in Prepare
Conditional Lookup multiple values

I have the following set of tables: A (key1, key2) B (key2, key3) In that case, every key1 can have multiple key2 attributes in table A and every key2 can have multiple key3 attribues in table B. When I would use a conditional lookup field for table A to get key3, it would only give me one of the key3 attribues, is it possible to take all values? I know I could do it with a simple custom view left joining on key2, but is there are recommended way to do it in Discovery Hub without custom views? So the goal table should be like C (key1, key2, key3)

901
JTreadwell
Employee
G
Visitor
ghazyVisitor
asked in Prepare
How to RoundUp or RoundDown Decimal

Dear TimeXtender's Team,What is choice to setting rounding in TimeXtender if we want to set up decimal ? Like example .. in Original Data is $12,3456, we just want the result is $12,34 (2 decimal)because in TX, it will be $12,35Thank you,

312
JTreadwell
Employee
R
Participant
r.miltenburgParticipant
asked in Ingest
GML field

In one of my single text files is a field which is actually a GML field. When i'm trying to deploy and execute this field as varchar(4000) it gives me the following error: 'string or binary data would be truncated' So I wanted to override data type vut this seems to be impossible when your data source is a single text file. So I tried something else, i made an Excel file of my csv file and read objects from data source as Excel, but then my GML field isn't even visible in the data selection tab. is there another possible way to insert my GML file in TimeXtender without getting an error?

536
J
Contributor
M
Explorer
mchinskyExplorer
asked in Prepare
Sorting a Hierarchy differently

I'm trying to create a hierarchy of GL accounts and the category they belong to. (i.e. Assets, Liabilities, Equity, Income Expenses).However the Hierarchy is displaying alphabetically.  If it were to be sorted by the first GL account it's associated with, it would sort correctly since GL accounts are numbered in the proper sequence.However, when I tell the Dimension, "Parent Category" (which is the Assets, Liabilities etc) to sort by Attribute Key, when I deploy I get an error saying it can't be used as an attribute because it is not related.Is there a workaround to this?

821
J
Contributor
J
Starter
j.romijnStarter
asked in Prepare
Table truncation options

Hi guys,Can someone elaborate the different options of table truncation? I can't really find it in the help or e-learning. We have set up an incremental load on a large table in the ODX, initially in simple mode. We found that the data after deployment & execution exists in the valid table and in the raw table, occupying twice the available storage of the original table size. We then disabled simple mode and checked the truncate raw table before transfer. I now still see some records (not all of them) in the raw table. I guess I'll have to check "Empty raw table after data cleansing" to completely empty the raw table after reloading, but I can't really grasp the difference between these options. 

3253
W
Contributor
A
Explorer
ajiExplorer
asked in Prepare
Implementing Scalar Function with COALESCE in TX

Hi TX Support,I wanna know how to implementing scalar function with COALESCE in TX ? Here I attach the function, could you please tell me how to do that?USE [QAD_DATA]GO/****** Object: UserDefinedFunction [dbo].[GetAliasesByWo1] Script Date: 03/20/2018 16:15:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[GetAliasesByWo1](@item nvarchar(max),@length float,@catego nvarchar(max),@opt nvarchar(max))RETURNS varchar(max)ASBEGINdeclare @output varchar(max)select @output = COALESCE(@output + ', ', '') + wo_lot + '=' + convert(nvarchar, wo_qty_ord)FROM wo_mstr_datawhere wo_part = @item andwo__dec01 = @length andwo__chr01 = @catego andRIGHT(wo_rmks,1) = @opt andwo_status = 'R' andSUBSTRING(wo_routing,1,6) = 'REWORK'return @outputEND 

245
A
Explorer
R
Participant
r.miltenburgParticipant
asked in Ingest
CSV file as datasource

Hi community,We are trying to get a csv. file as a data source in the Discovery Hub.We've tried the 'Edit single text file', but when we import the columns, it doesn't give us the data in these columns.You got any idea how to handle these csv. files in the Discovery Hub?

561
Thomas Lind
Community Manager
J
Contributor
jyothi.dosiContributor
asked in Prepare
Format standard measure to hh:mm format.

HI  I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.

192
J
Contributor
B
Starter
birkirStarter
asked in Jobs & Executions
Change data management or incremental loading with changing data

Hi,I have a source table in Navision which contains inventory data. The data is sometimes changed back in time due to miscellaneous reasons. I have so far handled this with change tracking in Sql Server and then I do a merge statement that either inserts new data or does an update on older data already in the fact table.So my question is how could I handle this in TX and do a incremental load?Regards Birkir

1704
R
Participant
K
Visitor
kgtsVisitor
asked in Jobs & Executions
Changing environment properties

Hi all I recently changed the environment properties of the development environment to have the AX data source point to the live environment instead of the test environment. I hoped that executing (without deploying) the staging area would refill all staging tables with live data instead of test data (all full loads, no incrementals), but it didn't. In fact, what needs to be done, is deploying by manually marking all tables to be redeployed in the deployment screen, as nothing has changed according to TimeXtender. Is it possible to make the SSIS package connections dynamically looking at the environment properties (this way an execute would suffice)? Or mark the staging tables to be redeployed? TimeXtender version 16.8.1.64; project is using SSIS. Thanks!

331
JTreadwell
Employee
S
Participant
satish.padarthiParticipant
asked in Prepare
Custom Data on a table

I can see the custom data on the table when I go and check advanaced. How to know where does it exactly points to? I am trying to find the location and file name of the excel sheet I loaded.

361
JTreadwell
Employee

Badge winners

  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
  • Certified Solutions Architect
    JeroenStahas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings