Ask general questions
Hello fellow TimeXtender users, We were wondering: is it worth upgrading from SQL 2014 to 2016 in the scenario where we use TX traditionally: stage - dw - cubes. Has anyone done it and have you seen performance improvements? Thanks! Wim CALM - Co
Did anyone have a data dictionary that has been pulled from timextender system database. The ideal one I am looking at is either a search option on a html where you can look for a table with all the columns, descriptions and data mapping(source). Or if anyone did similar one on an excel document will equally help me.
Hi,We are trying to read a csv file and truncating some columns because our table would be too large otherwise. Unfortunately deploy and execute fails with this error:"Data conversion failed. The data conversion for column "name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."."We are pretty sure it isn't an encoding problem because when we increase the column size ("Length") in "Edit multiple text files"->"Columns" we can read the data just fine so the error must occur because of the truncation.Does anybody know what options we have to use to let TimeXtender know that we are ok with the truncation of the data in the columns?Thanks,David
Just after some advice about whether something is possible.I have developed a data-warehouse that encompasses all products, However due to the nature of the business what I want to do is create two separate cubes, both that only report on a selection of the products, i am trying to avoid extra security roles in Targit which is used to browse the cubes or creating extra SQL tables which i believe would enable me to achieve the result but with more to manage.Is it possible to add a filter to a cube so that it only includes some dimension members?
HiI know it is quite silly but I am not able to be figure out how to convert a measure which is in 4.97 into whole number as 5?
Hi,to configure the multiple environment setup I used the PDF (https://legacysupport.timextender.com/hc/en-us/articles/360001136526-How-to-configure-Multiple-Environments) , and everything works well when all the firewalls are turned off.We have opened port 10001 and 5001, but when the firewall is turned on, my DEV environment can't connect with the Production environment.My setup now is a Development server and a Production server.When I want to connect from Development to Production, I see the servers negotiating on port 10001 and 5001. But after that, they continue to work with a port in the 64xxx range (examples: 64135,64177,64281 etc) e.g. a random port.My firewall won't except this, and I would like to know if it is possible to work with a standard range / port so we can configure our firewall accordingly.Kind regards,Rogier
Hi Can anyone please help me as I am struggling to increase the font size of TX window, it is too hard to read table names
We are providing clients with a preconfigured data warehouse for an ERP system. We will continue to make enhancements and improvements.The client will eventually add additional fields and user defined fields for their own needs.What's the easiest way to merge in our improvements to the changes they have already made to an older version?
what is the right scenario for using single quotes to wrap project variables? Let's say i have a data constraint added to a field and i am using a dynamic project variable like, soin this scenario, i am comparing a data to another date, and i have the variable encased in single quotes.I always assumed the single quotes was how Discovery Hub "renders" the underlying variable, but i recently found that my assumption was untrue. is the single quotes only to be used when evaluating a character string? or are there some rules to apply wrapping in single quotes. Note: the variable above is a dynamic -> select max({datefield}) from {table} statement, under the covers.
When setting up the global database for the DWH, I get this error:"Databricks direct write requires SQL Server Authentication"However, my environment properties are straightforward and I can't find anything "databricks" related in the settings.It's a recent (2019) version.Anyone knows what this error could allude to?
There is no zoom in/out option in the version 20.5.8.64. Is it available in the latest releases of TX?
Afternoon, I am getting this strange error when I run the Cubes on TimeExtender. There were patches that were applied to the server over the weekend where TX is running from. I am not sure if that could be the cause. Please find the attached Error screen.
Hello guys, i need some help Our environments data are outdated. When we check that the services of Timextender both in Stopped condition As far as i know, the 'Timextender Server' service should be able to start/running.But when i try to run it (both in WServiceTools in TX or in Windows Service apps service) but it just start and stopped it said error 1788 (As on attachment) the account that being used is LocalSystem which is the System Account. I've tried as support.timextender article told but no luck Can somebody give me help whats the problem ?
HiI am connecting to a SQL database.I can browse the database through SSMS and i can "Test connection" successfully.The problem is that i cannot read objects from the database. I get the following error:If you need assistance, please submit this with your ticket.Undetermined SQL Server version during read of source schemaLocation: Business Unit 'test', Data Source 'test'.Details:Undetermined SQL Server version during read of source schemaModule: timeXtenderSystem.Exceptionat TimeXtender.DataManager.DataSource_Sql.get_IQuery()at TimeXtender.DataManager.SSISEngineBase`1.CreatePackage_InformationSchema(IInformationSchemaProvider informationSchemaProvider, IDataSource_Sql dataSourceSql, ReadInformationSchemaType readInformationSchemaType, Guid sourceId, Boolean deleteExistingRecords, String queryOverride)at TimeXtender.DataManager.DataSource.RefreshInformationSchema()at TimeXtender.DataManager.ReadDataSourceObjectsCommand.Read()at TimeXtender.DataManager.ReadDataSourceObjectsCommand.<&g
We currently execute an SSIS package via Execute External SSIS Package. We want to start using SSIS environments to better manage dev/prod values and passwords. The problem with the Execute External SSIS Package is that we are not able to call the SSIS package using an SSIS Environment. To get around this, we created a Script Action that executes the SSIS package with an SSIS Environment, and then set this script action as a Post Script on a table that is executed in our Execution Package. The problem I am facing is that calling the SSIS package in this manor calls it asynchronously. Is there a way to synchronously call an SSIS package with an SSIS Environment?
Hello,I tried creating a new TX Dictionary project on our Tableau Server, but I'm running into some problems with opening the Tableau-file and replacing the data source.First of all, the stept to replace the datasource aren't up-to-date anymore with the new Tableau Desktop versions. In the new versions you have to open the new datasource before you can replace it. Not a big problem, just a mention so you can possibly change this.The problems come when I replaced the datasource. All sheets are empty and a few fields keep giving an error. The error states that the field doesn't exist in the database.I'll assume the missing fields are the reason for the empty sheets, as you can see here below:Can you help me with this problem?Kind regards,Damien van Kan
Hi, In my scenario, I rely on a stored-procedure in the source (external) database to create the table which will be used in TX. The stored-procedure might have various table/view/functions dependencies. Is it possible to import stored procedure/scalar functions into ODX layer? I know it's possible to recreate (internal) stored-procedure, however I have no access to the underline script in the stored-procedureKind regards.Dror
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
