Skip to main content
To homepage To homepage

General Q&A

Ask general questions

133 Topics
T
Participant
truttafiskerParticipant
asked in General
Copy Semantic layer or Copy tables/relations from exsisting semantic layer to new ?

is it possible, as the title says .. to Copy and entire semantic layer to a new semantic layer, or copy the exsisting tables with relations from 1 semantic layer to a new one ?

131
Christian Hauggaard
Community Manager
Dean
Starter
DeanStarter
asked in Interoperability with other Platforms & Tools
SSAS tabular TimeXtender/PowerBI

Hi, I am working with TimeXtender and have an SSAS tabular on-premise on a virtual machine as the endpoint. I want to publish my Power BI dashboard to the Power BI service. However, when I attempt to publish, I receive a message indicating that the connection to the data source is broken. How can I resolve this issue? We do not have Power BI Premium licenses, hence the use of SSAS. Looking forward to your response. Best regards, Dean

314
rory.smith
TimeXtender Xpert
P
Explorer
Pieter-JanExplorer
asked in Legacy & Upgrades
upgrade to 20.10.63

Hi, I'’ m upgrading from 20.10.52 to 20.10.63 and are waiting for a long time (over a hour) message “please wait while the application is preparing for first use” and after a while a message “installer not reponding “ with a retry or cancel. Is this normal behaviour?

388
P
Explorer
Dean
Starter
DeanStarter
asked in Interoperability with other Platforms & Tools
How can I use tables from TimeXtender Data Integration in TimeXtender Data Quality?

I am currently working with TimeXtender Data Integration and would like to leverage the tables created there within TimeXtender Data Quality. Could someone provide a detailed explanation or step-by-step guide on how to achieve this integration?

271
P
Starter
P
Explorer
Pieter-JanExplorer
asked in Legacy & Upgrades
upgrade TX from 20.10.52.64 to 20.10.63.64

Hi, our version is 20.10.52.64. Noticed the the Cdata connectors are disappeared for new connections, so want to upgrade to newest version. According to me that is 20.10.63.64 if I'm correct. Are there things to take into account when upgrading to this version? Can I just run the upgrade script from my version to this newest version? Also, is this new version a good version if i eventually want to upgrade to TimeXtender Saas in the future? I've read Download TimeXtender 20.10 – TimeXtender Support, so i know from the "backlog issue” Just want to get confirmed i'm doing the right steps, things, version upgrade :-) thanks!

251
Thomas Lind
Community Manager
S
Starter
summronStarter
asked in General
Custom Data Source

At one point you had a link to describe how to write a custom data source so it will show up in the list of Custom Data Sources in TX. Can you link me to that documentation?

416
S
Starter
M
Participant
MMMParticipant
asked in General
How to set up TimeXtender Desktop on a local Machine

Hi, I have a virtual machine that is currently hosting the ODX service and I would like to get my local machine up and running with TX desktop. I have installed the application but am getting an error that can be found below. I have looked through the documentation regarding this but it seems that the legacy documenation is all I can find with anything relevant. In the screen shots it is asking to review settings in the ODX tab and the Project repository tab which are non existent in the latest TX version I am using. I only see General and Customer editors when looking at Tools>options. ERROR> A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) Details: SQL Server: 'sql-instances-prod.database.windows.net'SQL Error Number: 64

11823
Christian Hauggaard
Community Manager
R
Contributor
RLBContributor
asked in Legacy & Upgrades
Renaming a table breaks related tables

I have a table (table A) with a lookup field from table B (using the default relation between A and B). This works fine. Table B is then renamed because of a spelling error, deployed and executed. Good. Table A still seems to be OK: the relationship between A and B looks fine and the data cleansing procedure (Advanced -> Customize Code -> Data Cleansing Procedure) contains table B with its newly updated name. However, table A won't execute because the deployed version of the data cleansing procedure still references table B's old name. The simple fix is to force a deployment of table A, but I think TimeXtender should have noticed that a deployment was needed (red table name). Seems like a bug to me. Legacy version 20.10.50.64 Details: SQL Server: 'my-mdw-database.example.com' SQL Procedure: 'MDW_TR.usp_table_A_Clean' SQL Line Number: 65 SQL Error Number: 208 Invalid object name 'MDW.table_B_old_name'.

928
Christian Hauggaard
Community Manager
avanrijn
Contributor
avanrijnContributor
asked in Legacy & Upgrades
End of support TX version 20.10

Dear Sir, One of our customers wants to keep working with TX classic into the future. Question: Till when is the 20.10 TimeXtender Classic supported ? Customers have to migratie sooner of later right ? Is there a deadline ? Or is TimeXtender Classic still supported for say the next 10 years ? Hope you can shine a light on this. 😀 Regards, Arthur

1357
avanrijn
Contributor
A
Problem Solver
aftabpProblem Solver
asked in General
Unable to open project

We are suddenly having issues with opening last saved project in TimeXtender. The error says: An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the parent table.. We have tried to go back to the project that we saved before the lastest one. We are able to open that it not able to save it. The errror says: An error occurred while saving the project to the database. An error occurred while fetching data from the database.Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. Location: Table: SelectionRuleFieldsForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist

151
Christian Hauggaard
Community Manager
L
Participant
luuk.boumanParticipant
asked in Legacy & Upgrades
Will upgrading the ODX service change the ODX repository?

Hello TimeXtender Support, We are looking to upgrade the ODX server at the customer. Currently the ODX service is installed on the PROD server. We first want to install the new version of the ODX service on the DEV, basically run a sandbox project to ensure everything is running fine and then upgrade the ODX service on PROD. Now, I've been told by Rory that there is a change that running a newer version of the ODX service will impact the metadata in the ODX repository in a way that is irreversible. I want to make sure that we can first try the new version of the ODX service in the DEV environment without impacting the ODX repository, so we can go back to the previous situation if anything problematic pops up and don't impact PROD. My question is: can we safely install a sandbox version of the ODX service on the DEV server and have it call home without irreversibly changing our ODX repository between these two versions? ODX Service 20.10.37>ODX Service 20.10.57 Hilsen, Luuk Bouman

456
Christian Hauggaard
Community Manager
R
Visitor
RemyBVisitor
asked in General
Missing module in TimeXtender Classic training

In the TimeXtender Classic training, I only see 4 modules, while Peter Jensen (element61) sees 5 modules. See below screenshots. We are wondering why Peter has a module named ‘Business units’ that I don’t see.

273
Christian Hauggaard
Community Manager
T
Participant
truttafiskerParticipant
asked in General
ExecutionEngine_x64 and JetDatamanager takes alot of resources

hi there After the latest update executionengine_x64 and Jet datamanager server takes 100% of my cpu .. are there anyone who have experienced the same ?

658
T
Participant
peter.jensen
TimeXtender Xpert
peter.jensenTimeXtender Xpert
asked in General
Repository cleanup

We're experiencing projects to open very slowly using TX 20.10.38 (we're above version 10000 of the project) Is there an easy way to remove old versions of a project ? We are using multi environment with global databases, and don't want to go through the export, create new repo DB and import hustle.We're also trying to delete the logs, but deleting them from within TX seems to take forever.

35211
D
Participant
Christian Hauggaard
Community Manager
Christian HauggaardCommunity Manager
published in Interoperability with other Platforms & Tools
Public Preview - TimeXtender on MS Fabric - Feedback

Many TimeXtender users have started experimenting with TimeXtender Data Integration on Fabric. As this is still in Public Preview, we really appreciate your feedback regarding: bugs/errors missing documentation improvement suggestions new ideas Thank you for your engagement.

351
rory.smith
TimeXtender Xpert
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in General
Multiple Environment Transfer

Good Day One of our clients who use TimeXtender (20.10.47.64) experiences a Server Memory issue in Production when IT Operations opened the Multiple Environment Transfer Window. IT Operations reported that the window took ages to open but did eventually open. The Network Administrator did then have to hard reboot the server in order to get it to respond. Attached are the messages reported within TimeXtender.

728
rory.smith
TimeXtender Xpert
A
Participant
annfossParticipant
asked in General
Missing Relationships in Relation Diagrams

Hi, I am currently working in TimeXtender Data Integration (version 6766.1) and would like to view the relationships between my tables. However, when I access the “Relation Diagram,” I do not see any relationships—neither between tables across different data areas (e.g., DSA and MDW) nor between tables with lookup fields. Is there a specific setting I need to enable to view these relationships? The data lineage for specific fields is functioning perfectly.

485
A
Participant
lstegmeier
Visitor
lstegmeierVisitor
asked in General
TimeXtender Solution Architect

Hi, I previously obtained my TimeXtender Solutions Architect certificate. How can I get the badge to show up in the community? Kind regards, Ludwig

371
Christian Hauggaard
Community Manager
G
Starter
gdlc_esculineStarter
asked in General
Is it possible to show the data lineage of a table filled through a Custom Table Insert?

Hi, Is there a way to view the data lineage for tables populated using the Custom Table Insert method? When we select the “Data Lineage” option for a column in a Custom Table Insert table, it only shows the data lineage with that table as the source, rather than displaying the tables used within the Custom Table Insert itself. I saw that this post had a similar question like mine, but I couldn't find an update about it: data lineage for custom table insert | Community Thank you in advance!

342
G
Starter
M
Starter
Marius_dWStarter
asked in Legacy & Upgrades
How long is my version supported

Hi, I am using TX 20.10.45.64. Can you tell me when support for this version will end?

681
Thomas Lind
Community Manager
M
Starter
mmax77Starter
asked in Security & Compliance
Role Level Security Enforcement

Hi all, We implemented a semantic model on Azure, granting access to our users through Azure AD groups. By creating roles that include Azure Tenant IDs and enforcing Row-Level Security (RLS) dynamic settings. However, we’ve encountered a challenge: when changes are made to certain fields, the RLS configurations can sometimes fail to enforce restrictions properly. This can lead to unintended access, where users in an AD group suddenly find themselves with visibility into all data, rather than the limited data they should see. To address this, we’re exploring ways to implement a more restrictive access model within the RLS role configuration. Specifically, we’re considering options that would prevent any data visibility until RLS settings are confirmed to be operational. Proposed Solution: Initial Data Restriction: Until the RLS settings are validated, no users should have access to any data. Validation Checks: Implementing a validation mechanism to ensure RLS settings are working correc

965
Christian Hauggaard
Community Manager
avanrijn
Contributor
avanrijnContributor
asked in Legacy & Upgrades
Mirgration Tool Dialog Box Question

Dear Sir, The migration Tool is giving me this dialog. Is there anything I can do ? Regards, Arthur ExecuteBulkInsertQueryStep Failed at Step BusinessUnits.Adding to table [dbo].[ODXConnects] Violation of PRIMARY KEY constraint 'PK_ODXConnects'. Cannot insert duplicate key in object 'dbo.ODXConnects'. The duplicate key value is (47f7cfb0-0337-40bc-b508-79172aec7258, 99999999). The statement has been terminated. Details: SQL Server: 'sql-instances-prod-002.database.windows.net' SQL Procedure: '' SQL Line Number: 1 SQL Error Number: 2627 Violation of PRIMARY KEY constraint 'PK_ODXConnects'. Cannot insert duplicate key in object 'dbo.ODXConnects'. The duplicate key value is (47f7cfb0-0337-40bc-b508-79172aec7258, 99999999). ...

382
avanrijn
Contributor
G
Contributor
gediminas.juskenasContributor
asked in Security & Compliance
Row-level security on semantic layer dimensions

Hello, I have created a semantic model of my project which is implemented as SSAS endpoint. Users usually connect to it through excel and browse the model. Fact tables are connected to dimension tables using ID key. I want the fact table to be filtered based on values on one of the columns in dimension (fact table has millions of records and there are around 500k distinct IDs of the dimension within it). Question is - if i apply row-level security on one of the columns in dimension - will it apply that to fact records as well? Or i must specifically apply the RLS onto the fact itself? Thank you

863
G
Community Manager
L
Explorer
linda.monincxExplorer
asked in Infrastructure & Networking
Does Timextender version 20.10.44.64 support tls 1.2

Wondering if Timextender version 20.10.44.64 support the new TLS 1.2 version

634
Thomas Lind
Community Manager
oscarcleve
Contributor
oscarcleveContributor
asked in Infrastructure & Networking
Connect instances to existing SQL Server databases for storage

Instead of creating a database from within the TimeXtender interface with the Create Storage option suggested in the standard procedure, I want the TX instances to be connected to exisiting databases on an SQL server. I want to do this for ODX as well as MDW instances. The SQL login to be used by Timextender is not allowed to have sysadmin or dbcreator privileges on the SQL Server, and can therefore not be used to create the databases. If I press Create storage with the name of the existing database specified for the instance in the portal, I get an error message saying the database already exist, but with no visible option to utilize the database. Application Portal SSMS Database How can I connect to existing databases for instance storage instead of creating new ones?

704
Thomas Lind
Community Manager

Most helpful members this week

Badge winners

  • 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
  • Ingest Expert
    nmohas earned the badge Ingest Expert
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings