Prepare

Hi,We are migratring i customer from version 20 to 21. In version 20 they use a system variable to limit the amount of data loaded into certain DSA tables in the development environment.is there any way to accomplish this in V21 - setting a variable that only affects one instance?BRAnders

I have a table which loads incremental in the ODXIn the datawarehouse the table is on Automatic and in simple mode.The setting to keep fields up to date is off.Will the incremental records from the ODX do inserts and updates, but update only on the fields with no transformations/lookups or will no updates be made at all when an updated existing record is retrieved from the source?As we don’t have any transformations in that part I was hoping we could skip the RAW table and that records get updated if newer versions come by.The documentation only mentions what the ‘keeping fields up to date’  does for lookup fields , transformation fields and so on, not what exactly happens when that box is not checked 

I am working with a solution that delivers 3 end pointsThe first end-pointhttps://data.mysystem.com/86fb92b5-ae9cData from this end-point is aleady in the DVHid is the unique id for the attached document:{ "Type": "images", "fileName": "some_file_name.pdf", "id": "3de1cef70101", "mimeType": "application/pdf" }The second end-pointTo reterive the document the endpoint ishttps://data.mysystem.com/attachment/<id>This gives the output as ANSI%PDF-1.7%����1 0 obj<</Type/Catalog/Pages 2 0 R/>>endobj2 0 obj<</Type/Pages/Count 21/Kids[ 4 0 R 27 0 R 31 0 R 37 0 R 46 0 R 48 0 R 50 0 R 54 0 R 56 0 R 60 0 R 62] >>endobj3 0 obj<</MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_Enabled(true) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_SetDate(2022-10-05T08:45:49Z) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_Method(Standard) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_Name(Lav) /MSIP_Label_7a2396b7-5846-48ff-8468-5f49f8ad722a_SiteId(e6795081-6391-44

Hi there. I‘m having trouble with a three tables in my project. What they have in common is that they are tables that I created specifically (that is not with a mapping to ODX) and populate with a Custom Table Insert.The problem seems very similar to this one: Data Clensing results in time out | Community (timextender.com)For example, I deployed and executed one of my tables yesterday evening (not a large one, about 20.000 rows). And these are the results: I’m not sure what the problem is but the tables are able to finish execution if the Custom Table Insert is set to valid, however then all my lookup fields (and fixed value fields) are null. If it’s set to raw, then the execution of the data cleansing rules seems to go on forever. In relation to the answers to the other question from @Bernarddb, then yes Operator for the lookup fields is normally always none for me (but I also don’t get exactly the same error): Some of the settings might be wrong perhaps: - Tables are not guarded on d

HelloDon’t know if this is a bug or a deliberate choice, but when you want to add a transformation on a field in a table that was opened in ‘new window (CTRL+W shortcut), then the section for Field Transformation is not available.I have included a picture.When your table is in the DSA/MDW node and you do right-mouse click, then you can choose Field Transformation.When your table is in a separate window, then this particular option is missing

Dear Support,I have encountered a strange phenomenon with the history settings and need urgent support.Situation:Records which were once flag as new records from the ERP system show up as SCD Is Current is 0. These orders were canceled in the ERP as a next step and flagged correctly in the history raw table table as a type II change (which is correct). However, they do not get inserted into the valid table as new record. Today we realized even more records are missing in the valid table. TX Version: 20.10.40.64.Please advise on how to proceed. This is causing us major issues in our month end closing reporting. It used to be fine and we only experienced it this week. Thank you.Oscar

Hi guys,Somehow I am unable to create a job for my semantic models or my datawarehouse/ data area. I can’t select the model when I’m trying to add a new job.  

Good morningI am deploying a specific table with history (mostly type2) to Snowflake.However in the generated script the semicolumn is not placed correctly (after the ; some additional ‘and’ clauses are added). This results in an error creating the data cleansing procedure. I added the script in the attachment.Can you please have a look.

This problem arrived after the issue with SNK is resolved. I am not sure if the two cases are related in any way but that was the last change made in TX.I am trying to figure out why data clensing is taking so much time. It ultimately ends in time out:Error during Data Processing for Table: DSA.FACT_TABLE_A at: DSAExecution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Operation cancelled by user.Warning: Null value is eliminated by an aggregate or other SET operation.The wait operation timed outStored Procedure: [DSA].[usp_FACTABLE_Clean]Parameters:@version = 2177Line number: 0Details:SQL Server: 'TEST-SQL-SERVER'SQL Error Number: -2The total number of rows in ODX are 9 664 965. It shouldn’t take more than a few minutes to transfer and data clens ! 

Hi Team,We have a data provider for which we need to connect to MySQL. We want to incrementally bring data from the source, but the problem is that all the columns in the table are of the string data type. This prevents us from setting any incremental logic on the date column, which is currently stored as a VARCHAR(8). I tried casting the column to a date format, which works in the query tool, but when I try to add the query table, the option is disabled. I am using Mysql 5.1 client data source.Could you please suggest how I can achieve this?

Is it possble to create a table based on CTE in timextender, or how would you do it? 

Hi everyone, back again with another issue.  We have now setup our ODX with storage account as storage layer. refreshing it sometimes breaks though. I'm getting 404 error, path can't be found. This happens with transfer all option. When I run the set of tables one by one, everything seems to be fine. I saw 1 more post like this for oracle, where the connector got updated. We're using an older version so I suppose can update the cdata connector and try again. However: the weird thing is that this also happens with ODX to DSA. Any clue how this is possible? Path does not exist, but I can find it in the storage account. 

Dear all, We have tx instaled on Azure and on premise. The version we are using is 20.10.52.64. how is it possible that on the onpremise we can use the custom data selection rule and on Azure this screen is not appearing in the DSA?The issue we are facing is that we want to limit that data we want to load in the odx when the raw table is being executed. Therefore we want to set a customized data selection tule on the mappings.Why this option is not in Azure but it is there on the on premise?We want to load / keep all data in the odx server and make a data selection rule in the DSA..Imagine we are migrating from on premise and we want to show only 15 months of data instead of  10 years. Only if the customer is asking for it we will load it.  This is working on the on premise perfectly.Now that we are migrating from on premise to azure we are missing the most used data selection rule. And the advised work around 

See the screenshot. in the mapping you can see all odx sources with the correct name (ODX(BEBOO1): bronze.blueyonder_wms.DSCMST. However when I go the the field mapping The name for each source is now called local host????For trouble shooting purposes when missing a mapping. It will create a work around for us, because we have to click on the table to see all mappings on the right side then you have to go on be by one.  why the name have changed on a the field mapping? possible to have a fix for this? 

Hi all, I'm looking at making the right keys in our database model. I've been reading some topics on the forum but haven't found a shared opinion on the best practice. Super natural keys Advantage: Easy to use.   Disadvantage Huge performance impact. According to some topics reloads can increase in time from 3 till 30 minutes.  Their are relations in reloading the tables in the correct sequence. TX will calculate this sequence, however their is an increased change of circle references. Hashed Keys Advantage: Easy to use.  Should be faster than SNK. It doesn't need a look up to the keystore.  Disadvantage: Change on duplication of keyus is limited to a minimum Source: https://stackoverflow.com/questions/297960/hash-collision-what-are-the-chances Look up DW_Id from different tables Advantage: Able to make all joins on last layer. Easy to use.  BIGINT in keys, is better than VARCHARS in keys.  Disadvantage: It will cost the simple mode in transfering data from data area X

Hi again I have a table with the following values: I want to add the [No] from the first line (101) to all the other lines .. therefor I thought of making a SQL like this the following. I ​​​​​​Why is it my nested Select doesn’t work ??or are there a smarter way than what I thought of doing ?

I often get this pop-up when i Execute a table or a view. It could be either a new table/view or an existing.I get it in DSA and MDW. Dont remember getting it in ODXWhy do i get it?What happens when i click on Yes? What happens when i click on No?  

Hi alleI’m all new to timextender so please bare with me .. I have 2 tables which I have to join but there are duplicate values in both tables .. in one of the tables it’s ok if I somehow made an distinct data selection to it .. but I don’t know how .. I also looked into making a bridge table, but that wouldn’t at first hand solve my problem .. Do anyone have a sugestion on how I could/should make a relationship between these to tables or how I could make a data selection rule that somehow made an “group by” or “distinct” selection ?

Dear Sir,Our client is trying to promote/release their DataWareHouse from DEV to PROD.They are using the Environments page (https://app.timextender.com/data-estate/environments) in the Portal and after a minute or so this Error pops up:“failed with the error 'SQL errored whilst updating target tables”See Word attachment for screenshot details.Client is using TimeXtender version 6675.2Their is no detailed information for this error, so can you please give us a hint where to look for, to solve this.  We double checked all database connectivity for DWH and ODX.No luck so far.Please assist. Regards,Arthur

After upgrading to TimeXtender 6675.1, we are experiencing some errors when executing custom table inserts. The error message is ‘The given ColumnMapping does not match up with any column in the source or destination’.As it turns out, we have a few CTI's where the target column name was spelled with a capital letter when in fact the column name was with a lowercase or vice versa. This was never a problem but we had to correct this in the newest 6675 version. Has there been a change in where the CTI's target columns are now case sensitive?

I want to join 7 tables and fetch columns from these tables and make a different table from it, so is it possible in Timextender without creating a custom view?

I have a weird issue in my new TimeXtender project, where my tables in my dwh layer won't load data from the Business Unit. I have a very simple setup to start with. I have one business unit which loads a couple of tables, and the Bussines unit configured to store data on our “VMTXTD001” server in a database. The Datawarehouse uses the same database as the Bussiness Unit and should load from that Business Unit. But when I execute the DWH layer I get this message for all tables:  Start Time : 4/19/2023 4:14:08 PM End Time : 4/19/2023 4:14:10 PM on server: VMTXTD001-Execute Execution Package Default 'Failed'    Invalid object name 'VMTXTD001.dbo.DM_CRM_Replica_dbo__CustomAccount_DSA_dsa_test_T'.        Details:        SQL Server: 'vmtxtd001'    SQL Procedure: 'dsa.usp_CrDM_dsa_test_CRM_dbo__CustomAccount'    SQL Line Number: 12    SQL Error Number: 208        Invalid object name 'VMTXTD001.dbo.DM_CRM_Replica_dbo__CustomAccount_DSA_dsa_test_T'. To me the issue appears to be that TimeXtend

Dear Community,When I create a view in my data area MDW from a table which is in my DSA (=> I drag the table from my DSA are to the views in the MDW data area), the view auto parameterizes (which is great). I deploy the view in the MDW, read view fields and preview it. (all is still great).When I release this to my next layer (PRD) I suddenly get a erroer previewing the MDW view. When I check the view in the PRD MDW the parameterization is all gone.Have you encountered this? Is there a solution?Thanks= Daniel

I am loading a fact table from a staging table, both are regular data warehouse tables. When I create a data selection rule on the mapping table, I'm unable to select the conditional lookup fields or the system fields from the source table:  TX Version is 6590.1. In legacy TX, it is possible to select the conditional lookup fields and system fields for creating selection rules: We have implemented a workaround where we create an extra field in the DSA table that has a transformation that fills it with the value of the conditional lookup field. In turn, this extra field does show up in the selection rule fields because it is a regular field. But this is not a very nice or future-proof solution.Is this an intentional change and if so, can you explain why? Or perhaps this is a bug in TX SAAS?

Hello,I can’t seem to find out how to create a variable holds the name of the data warehouse environment in new TimeXtender (6626.1).I’m thinking of the name of the environment as defined in the portal, not the name of the data area.Thanks!