Ask general questions
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.