TimeXtender Desktop Q&A

Is there an option to set a default value for a simple table such that we can fill it with some value without doing any transformations. It then also should be possible to add fields for simple tables, but that you can only fill it with a default value. It would also be helpful in the DSA. 

Hi, I tried to execute a transfer task on my data source however I encountered the following error:  The execution failed with error:System.Data.SqlClient.SqlException (0x80131904): Property cannot be updated or deleted. Property 'OwnerId' does not exist for 'object specified'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String m

I am busy with de TimeXtender Learn (TimeXtender Optimization) en there is an exercise :  Right click DSA node and choose Automate > Add Suggested Constraints.  De instruction is on TX 20.5.6.64, we work with 20.10.23.64. I can't find this function. Is that correct ? 

Is there a way to create a many to many relationship in the Tabular model.I have one tableDataWith Fields Project , Amount I then have a project Device TableWith fields Project, Devicee.g. A, 1A,2A,3B,1B,2 I then have a project tableWith fields Project And a device tableWith fields device The issue is I want to see the data table by device and project. The main data table contains 32 millions records and the project device table contains 10,000 combinations  so a workaround by creating a new fact table by creating a full outer join on the two tables might be a little inefficient , thanks

I have a calculated measure that is the the total lead time from when we order a good at a supplier, until it has been received and inbounded.  Now I would like to calculate the standard deviation of the lead time. But I can't seem to get it working, what is missing?

I am unable to use the Add related records on a table. I get the error message "There is no relation between table-A and the table table-B". I have added a condition where the key in both tables should be equal. I have also tried creating a relation between the two tables in both directions but no luck. There is no mention in the docs that it is needed to add a relation before adding related records. I am getting a Warning that the source table is executed after the destination table. What am I doing wrong?

Is there a way to use IS NOT NULL as one of the join conditions on a lookup? I want to get the TOP (1) record where a field is not null, ordered by date. Currently I have to edit the _Clean stored procedure as custom code to add it, which is obviously not the best way to do things. Thanks

I have a package with an active schedule and now and then the package is, for some unknown reason, not executed.  Scheduler Service was running at the time of the preferred execution time. How do I resolve the cause of this issue?  

As of now we need to deploy the whole project from one environment to another. This requires a lot of effort. Let’s say is there is defect in TEST environment in a single component, then we need to do the fix in DEV and TEST manually only for that component. As TX doesn't allow to migrate only a single or multiple components. It has to be the whole project. It also causes a lot of dependencies if multiple teams are working on the same project.

When you set up primary key behaviour to 'error' you elegantly force all valid data to be unique combinations of your selected primary keys. But, how do you control what individual dataset is regarded as valid and what is discarded as error ? Is there a way to let the primary key violation error handling know, which record you consider the valid one ?  (e.g. based on min/max values in non-primary key data fields)

When I recently moved our production environment to a new server and was working on deploying the entire data warehouse in TimeXtender I had some difficulties. First I did a complete (full?) and managed deploy which seemed to be successful. When I then tried to run a few execution packages one of them said it was missing a view. Then I did a differential managed deploy and it listed a lot of objects not already deployed!! OK, so I ran that which seemed to succeed as well. Tried the execution package that failed again but with the same result. Third time I did a differential deploy but this time after the deploy was done I noticed that the scrollbar in the results dialog was not all the way up! There at the top an error message was hiding. I had guard on deploy on some tables which was highlighted and hence covering up the error message. The actual error was that a view was not able to deploy because of a user defined function was missing. This UDF is defined in TimeXtender so why does

Hello, So I am loading historical data into tables in TX created of Excel files. One file for property data, one file for casualty data. After some time the file format changes and they combine these two separate files into one file and add new fields. Can I create a new data source to load the new file but still use the original worksheet tab names such that the data will still load into the existing tables? Thanks in advance.   P.S. I am using Discovery Hub 17.12.13.64

I have a generic stored procedure that does some custom post processing based on the table that has just been reloaded (Executed).  The stored procedure takes a parameter "TableName".  I've created a Script Action that executes the stored procedure.  I need this Script Action to run as a Post Step after the last execution step is run for one of several tables.  I can create one script action per table with the tablename hardcoded, but I've got a lot of tables to work with and would really prefer do this as a parameter containing the current table name.  Is the currently executing table name available in a system parameter somewhere and/or is there a way to create one that can be referenced by a script action?

Good Morning, We have recently upgraded TimeXtender to version 20.10.15.64. Both in QA and PROD servers. We have TX ETL jobs that extract data from Oracle database server to both server every night. They run at different times. However, the PROD ETL job takes longer to extract data. QA ETL job takes quicker. 1. QA TX on average takes 3hours to extract data from PROD oracle. 2. PROD TX on average takes 5 hours or more to extract the same information from PROD Oracle. Sometimes this take longer than this. 3.PROD TX sometimes hangs the whole night. 4. PROD TX has higher specs than QA. 5. We have checked the Performance Indicators  on PROD server while PROD TX is running. The CPU, Memory and other indicators seems well. 6. We trying to figure out why performance on PROD is slow during the data extraction from Oracle. We have checked all necessary indicators to and we still don't have answers. Is there anything that you can advice us to check so we can understand why PROD is slower than QA

Essentially, I am currently creating csv files from extracts of many TimeXtender tables.  Let suppose the data in a table is a column which identifies each row by country and the table contains many rows for each country, then I would need to create a file for each ISO country that existed in the table.  I know how to do this by hand, but am wondering if there is a clever way of automating this in TX without having to build an SSIS package? Thank, Greg  

I am able to deploy the semantic model but when I execute it I get the following error message: The current operation was cancelled because another operation in the transaction failed. Details: The current operation was cancelled because another operation in the transaction failed.System.Exception Not much do work with Im sorry to say but this is what I get. This is the TXDictionary project and it has worked before i moved it to a new server. The rest of the project executes fine (ODX, DSA and MDW).

I have been running into a problem where my execution package keeps failing due to a deadlock between an index rebuild and a select statement on sys.tables.  TimeXtender is running both process' and one eventually gets killed and fails the entire job.  in subsequent executions it has always failed on an index rebuild, but not the same index.  Has anyone run into this issue or have any solutions?  here's the query.  SELECT SCHEMA_NAME(tbl.schema_id) AS [Schema], tbl.name AS [Name], tbl.object_id AS [ID], CAST( case     when tbl.is_ms_shipped = 1 then 1     when (         select             major_id         from             sys.extended_properties         where             major_id = tbl.object_id and             minor_id = 0 and             class = 1 and             name = N'microsoft_database_tools_support')         is not null then 1     else 0 end                       AS bit) AS [IsSystemObject] FROM sys.tables AS tbl ORDER BY [Schema] ASC,[Name] ASC

Enable Continuous Integration and deployment by integrating with Azure DevOps. This can be done if we can deploy components in TX based on scripts or commands. We need a task for TX which can be added to build and release pipeline of Azure DevOps This feature is in addition to the below feature request for enabling deployment of single/multiple components to multiple environments.     In addition to the below feature request https://support.timextender.com/hc/en-us/community/posts/360014857198-Add-feature-to-deploy-single-or-multiple-component-between-environments-instead-of-deploying-the-whole-project tion to the below feature request https://support.timextender.com/hc/en-us/community/posts/360014857198-Add-feature-to-deploy-single-or-multiple-component-between-environments-instead-of-deploying-the-whole-project

Is it not possible to create a semantic model with no endpoint? For me, the beauty of the semantic models is that I can quickly create views for 'data marts' where I can do data selection rules without having to write a single line of code.  In previous versions of TX I could use the Qlik (Deprecated) semantic model for this because it didn't need an endpoint in order to deploy the views. But the newest version(s) of TX does not support this. So what if I'm moving entire corporation's data visualizations to Qlik SaaS (basically Qlik Sense in the cloud)? Can I no longer use semantic models? 

I'm making a TimeXtender Dictionary using Azure (Azure SQL DB's & Azure Analysis Services). When deploying & executing the project I got an error for the StepExecutionTime table:Invalid object name 'MDW_etl.StepExecutionTime_I'. Details: SQL Server: 'bffa063c7c84.tr366.westeurope1-a.worker.database.windows.net,11009'SQL Procedure: 'MDW_etl.usp_CrDM_MDW_etl_StepExecutionTime_DSA_DSA_etl_StepExecutionTime'SQL Line Number: 16SQL Error Number: 208 Invalid object name 'MDW_etl.StepExecutionTime_I'.Module: .Net SqlClient Data ProviderSystem.Data.SqlClient.SqlExceptionat System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, T

I have a table with fields defined (call it Table B), but no mapping.  I am inserting into this by using Table Insert (from Table A).  Think Table A -> inserted into -> Table B.  In the picture below Table A is Projects from D365 at the bottom of the picture.  Table B is everything else in the image.     DataAreaId is a field defined on Table B and is populated successfully from the table insert.  I would like to have a field, Field C, that simply does a custom transformation which places the value of DataAreaID into Field C.  While the Table B is fully deployed and executed, I am finding that Field C is unpopulated.  In fact all fields in the image that take values not from the Table Insert directly are unpopulated meaning I also can't assign constants.    So, all of the DimensionDisplayValue - xxxx fields in the picture are empty after executing.  I have also noticed to my surprise that the raw table is empty.  Not sure if this is by design or if something on Table B can be rec

It would be ideal if we could use differential deployment in the semantic layer, particularly in SSAS Tabular, or at least choose which table I want to deploy, as opposed to deploying the whole model.   If I make a change to the DAX of a single measure of a 5 gb tabular model, it is less than ideal to then deploy the entire database and process full, just to see the effect of the DAX measure in a front end tool.   Developing SSAS tabular seems to be quicker and easier in VS because of this feature.

I just tried the TXDictionary project from CubeStore and managed to deploy the ODX (Business Unit) but when I start execution I get the following error: Invalid object name 'etl.ExecutionPackageLogs_I'.   Running TX 20.10.1.64

Currently we are facing a problem with memory resources when we're trying to do a data export. When writing a huge file, 4 gb, the memory allocated to this TX process takes up more resources than  we would like (> 22gb of RAM). Is there any possibility for breaking up the data export in partions, such that the process takes up less RAM? I would think there would be some kind of option like the data batch cleansing in the table settings, but I can't seem to find it anywhere.   Within the data export we use the TimeXtender File Export 2.0.0.0 provider. 

Hi, I have a large FACT-tables in my DWH (copy from a view in stage). I have tried to add partitions. I didn't help that much, so I removed it again.But since I removed it, the table can't be deployed. I get the below error. I can re-add the partition, but still the same error: An error occurred during drop partition function. See exception details for the failing objectAn error occurred during drop user defined function. See exception details for the failing object: Drop failed for PartitionFunction 'FactSalesOrder_History_PartitionFunction'.An exception occurred while executing a Transact-SQL statement or batch.Partition function 'FactSalesOrder_History_PartitionFunction' is being used by one or more partition schemes. Details: SQL Server: '.'SQL Procedure: ''SQL Line Number: 2SQL Error Number: 7706 I'm not sure how to find and drop what-ever TX is complaining about.Tried this:DROP PARTITION FUNCTION FactSalesOrder_History_PartitionFunction and then get this:Partition function 'FactS