To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

368 Topics

R
Starter
r.miltenburgStarter
asked in Data Warehouse

Sync between ODX and Datawarehouse

Hi, I am syncing my data between ODX (csv files) and my DSA_Clean data area (Data waehouse). No i’m constantly getting an error that 1 of my previous inserted rows doesn’t exist anymore. I’ve tried to sync all my possible steps, so ODX, Source, Data are, but I keep getting the error and I don’t know hpw to resolve this problem.I tried several steps:1 Add the table as new table in my datawarehouse area, but still same error.2 Remove and add column again 

3
Thomas Lind
Community Manager
40 minutes ago
boyclaesen
Contributor
boyclaesenContributor
asked in Semantic Models

Missing edit options > ' Edit Semantic Field' in SSL layer

Hello, I have built a data model in Timextender and with a Power Bi endpoint. In the Power Bi report I see certain fields summarized by ‘Sum’. In the SSL layer I only get the option to change te name and I am missing the 'Summarize by’ and the ‘Sort by’ option. What am I doing wrong?   

9
Thomas Lind
Community Manager
22 hours ago
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in Semantic Models

Perspective Missing Selected Tabular Cube on Deploy

Good Day,I have setup a Perspective in TimeXtender (v20.10.39.64) and it includes 3 tables and a Tabular cube. When I go to deploy this perspective from DEV to QA, the tables are listed in the deploy tasks but not the cube.I tried the following fix but this did not resolve the issue:Remove Tabular cube from perspective Save TX Project Re-add Tabular cube to Perspective Save TX Project Deploy TX Project Multi Environment TransferHas anyone ever run into this issue before?I am going to try to add a new perspective to see if this resolves the issue but it worries me for promotes going forward that objects maybe missing on my deployment/promotes.Kerry

14
JTreadwell
Community Manager
1 day ago
Roy V
Contributor
Roy VContributor
asked in Data Warehouse

Incremental load based on history table with soft deletes

I have table A with history enabled, all columns SCD type 2 except the PK and a record is marked as deleted when deleted in the source (with a seperate record).In the next data area / data warehouse (DSA) i want to create an incremental table B based on table A, but I do not want to have deleted records from A in table B.When follwing the incremental rule wizzard the incremental selection rule can be set based on the incrementaltimestamp but deletes can not be handled because table A has no deletes (is thomstone =1).How to solve this the easiest? I can only think of taking along the Isthombstone field to table B and delete the records in a post script but this should be possible musch easier I would say.Suggestions? 

13
peter.jensen
TimeXtender Xpert
1 day ago
Pontus Olausson
Visitor
Pontus OlaussonVisitor
asked in Jobs & Executions

Excel Online connector sometimes fail with "Error while listing workbooks for drive"

 Hi,I am running a legacy version of TimeXtender (version 20.10.40.64), where we have an Excel Online connection set up using CData ADO.NET Provider for Microsoft Excel Online 2022 (22.0.8389.0) as data source.This data source is configured to authenticate via Azure ‘client flow’, see picture. The app registration in Azure has the following permissions:  The data source works properly most of the time. It is able to list the worksheets it finds on the SharePoint site, and can fetch data. However, scheduled execution packages sometimes fails with the following error message:[500] Could not execute the specified command: Error while listing workbooks for drive: [generalException] General exception while processing. Details: Error while listing workbooks for drive: [generalException] General exception while processing. Module: System.Data.CData.ExcelOnline fx220l.yg at fx220l.IIu.m(Boolean ) at fx220l.IIu.X(tbp`1 , Boolean ) at fx220l.IIu.YI(LoL )

4
Thomas Lind
Community Manager
1 day ago
G
Starter
gediminas.juskenasStarter
asked in Semantic Models

Semantic layer (Analysis services) remove unused dimension values from endpoint

Hello, i use Semantic layer as an endpoint to analyze the data through Microsoft Excel. In my model i have Calendar table (auto generated by TX) which dates from 2015 up to 2030. Fact in my dataset has values only up to year 2026.When i open analysis services endpoint through Excel and want to filter values based on Calendar, i can see the empty row in filter. I assume this is due to the reason that Calendar dimension has values up until 2030, and the fact - up until 2026:Is there anyway to not show empty values coming from dimensions (that do not have matches within the fact) in the analysis services from semantic layer? Thanks!

3
daniel
TimeXtender Xpert
1 day ago
mnoordam
Contributor
mnoordamContributor
asked in ODX

ODX job status not synchronized with Portal

The ODX server stopped (per 25/8) synchronizing it's job status with the portal.Restarting the ODX Server does not solve the issue. Any tips?

2
mnoordam
Contributor
1 day ago
boyclaesen
Contributor
boyclaesenContributor
asked in ODX

Date field is converted to an integer.

Hello, To my understanding TimeXtender determines the data type of a column based on first x amount of rows, depending on your setup in the portal.  The fields in my source  come in as (dd.mm.yyy) for example: "05.03.2021”. I use a Storage Account with a CSV connection.  I would expect that TimeXtender creates a "date” date type out of this. However, is seems that if a field character starts with a '0’, it skips it. In the ODX it shows an Integer value '5032023’.ODX: Depending if a character starts with a '0’ the fields (dates) show up like: It counts for all date fields and costs me a lot of time to create a work around each time. I tried to override the datatype in my data source but without succes. Help would be much appreciated.    

3
Thomas Lind
Community Manager
7 days ago
E
Contributor
ebayContributor
asked in ODX

multiple Excel files to one

HelloEvery day, I have a new Excel file in the Azure storage or OneDrive account. I use OneDrive to test phase. These file’s name change with a new day. How can I this multiple Excel files to one? Is there a option for Excel like aggregate files option in CSV?Best Regards

6
Thomas Lind
Community Manager
7 days ago
G
Starter
gisliheiStarter
asked in Data Warehouse

Load large fact table incrementally takes "long" time.

Is it normal when loading fact table incrementally with new data, that it can take up to one hour?Are there any tips to have this incremental load to perform better?Moving records from staging table to fact tablefact table is 140 million records, new load is around 500 thousand records with new timestamp here is the execution log overview  the table is not that complex.17 fields are moved over, from staging to fact table1 field is from keystore3 fields are have custom value script table settings are..  we are running TX, version.  6346.1Azure database, running with 6 cpu 

1
daniel
TimeXtender Xpert
8 days ago
rvgfox
Contributor
rvgfoxContributor
asked in Semantic Models

Pause & Resume Azure Analysis Services in a job

I’m using Azure Analysis Services as a SSL  Is it possible to resume and pause using powershell in a job?Do you have some examples of configuration? 

4
Christian Hauggaard
Community Manager
9 days ago
S
Contributor
sierd.zuiderveldContributor
asked in ODX

ODX "Remove Unused Objects"

What does “Remove Unused Objects” do? I cannot find documentation about it. Thx!

0
S
Contributor
13 days ago
E
Contributor
ebayContributor
asked in Jobs & Executions

Incorrect job repository version. Expected 2.0.0.0 found 3.0.0.0

Hello Today I get this error, wenn I want to add new Job. We didn’t change the version and use TimeXtender 6143.1.  We updated all of data sources but doesn’t change. Firstly, I want to understand why I am receiving this error. If I encounter this message in the future, I want to comprehend what I should do. There is a similar topic, but since there is no version change, I want to reopen it. Xpilot recommends that we should use the new version. Is it correct?

6
E
Contributor
14 days ago
E
Starter
Eric van der VoortStarter
asked in Semantic Models

Semantic Models execution packages greyed out in Jobs

Hi Community,After creating a simple semantic model (one table) and deploying it to Power BI Premium I get an error for the connection to the source database. It says it cannot connect to the source database because of the credentials (we use SQL Authentication on our Azure SQL database in this case).Would be nice if we could configure that from within TimExtender (and perhaps there is a way?).After manually fixing this authentication issue. we are able to execute this endpoint.This is confirmed by checking the Refresh History. Now we try to add the created (and tested) execution package to a job. That is not possible because the execution package is greyed out in the Job and therefore to able to be added.What could be reason why we are not able to add Semantic Model execution packages to a Job?Thanks in advance. Kind regards, Eric  

1
Christian Hauggaard
Community Manager
14 days ago
ignacio
Contributor
ignacioContributor
asked in ODX

ODX Transfer error

Hi team!  I am contacting you because I am trying to transfer data from MariaDB to ODX and I received the following errorfailed with error:System.FormatException: The DateTime represented by the string is not supported in calendar  Any suggestion to solve it? Regards Ignacio 

7
Thomas Lind
Community Manager
14 days ago
B
Starter
BennyStarter
asked in ODX

Why does the app registration for the ODX need owner permissions?

Why does the app registration for the ODX need owner permissions on the resource? I would think that read/write permissions would be sufficient. Why does TimeXtender need the “extra” rights?

2
B
Starter
15 days ago
rvgfox
Contributor
rvgfoxContributor
asked in ODX

Azure Active Directory data source conector

Hi, can you provide me with detailed instructions on how to set it up?

1
Thomas Lind
Community Manager
16 days ago
G
Starter
gisliheiStarter
asked in ODX

New field not available from ODX, in the data movement.

New fields from source are not showing in the Data Movement pane.New fields are added to the source database, the new fields and data are in the ODX, I can see the new fields in the parquet files, but the fields are not showing in the Data Movement pane.I have tried to run the function in ODX “Synchronize Object”I have tried to run the “Synchronize” task in the odxI’m Running Timextender Version 6346.1

8
G
Starter
16 days ago
E
Starter
Eric van der VoortStarter
asked in ODX

Theobald Extractor with incremental load just for 1 table

Hi All, Is it possible to use an SAP Theobald Extractor with incremental load and that just for 1 table ( or more, but not all the tables? We tried is on one table and we got an error message saying we needed to change all the tables into incremental load.Kind regards, Eric 

3
daniel
TimeXtender Xpert
20 days ago
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Semantic Models

Is there any easy way to change the source instance for an SSL after copying?

Hi,We have different instances for the development, test and production environments at a customer. Both MDW and SSL.After copying the instances from one environment to another, it would be nice if you could easily switch source for the target SSL to the MDW in the same environment. Under Synchronize with remapping, one must change the instance, data area, schema and table for each table in the model. it would have been smoother if you could switch instances for the entire model with one change.The easiest would have been if you could choose whether these settings in an SSL should be overwritten or not when copying.BRAnders

3
rvgfox
Contributor
23 days ago
christian.koeken
Contributor
christian.koekenContributor
asked in Semantic Models

Can't add a new column to semantic model

Dear Support,I'm having a problem with adding a new column from MDW area to the semantic model (tabular).I synced the model, I see the new column in Data Movement on the right side, but when I try to add the new column to the table it belongs to in the semantic model I don't get a 'plus’ symbol. It is a column I want to add to a fact table.I tried to reboot the server, but that didn't solve it. I opened another semantic model and tried to add a new column to a table and that worked. But for some reason in this model it won't. Can you help me?TimeXtender version 6143.1  

8
Christian Hauggaard
Community Manager
23 days ago
daniel
TimeXtender Xpert
danielTimeXtender Xpert
posted in ODX

Error when connecting to ODX Instance during ODX Server configuration

Dear all,I'm trying to set up a completely new ODX Server. I've installed the ODX server and made all the required configuration. When th ODX Server needs to connect to its instance i'm getting this error:I've checked all the firewall settings and I've done all the checks in this document: Configure your Firewall | Community (timextender.com). Furthermore we've added the timeXtender.exe and the OdxServerConfig.exe to the whitelist of the Windows defender firewall.The weird thing is that aswel TimeXtender as the ODX Server config can find the instance, but still we're getting this error. Does anyone know what I'm doing wrong? Error occurred while determining instance version or during performing aut. upgrade:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error

2
rory.smith
TimeXtender Xpert
26 days ago
P
Participant
pontus.berglundParticipant
posted in Data Warehouse

Best practice when using Supernatural keys

Hi,I have seen clients use Supernatural key fields to create keys between the fact and dimension tables, usually when the logical key is a combination of fields. I have seen these two methods used:The Supernatural field key is created in both the fact and dim table, using the same key store The Supernatural key is created in the dim table, then mapped to the fact table with a conditional lookupIs there a difference in performance here? Is there a best practice to advocate for? 

22
Thomas Lind
Community Manager
27 days ago
B
Explorer
businessintelligenceExplorer
asked in Jobs & Executions

Error loading project - Item with same key has already been added

Hi,I get this error while loading the latest version of a project.I also tried to load an ealier version of the project, but was not allowed to save it as the latest - getting the same error.What should I do? - Gabrielle

3
B
Explorer
28 days ago
K
Starter
KashifStarter
posted in Jobs & Executions

Incremental Data Load Issue

Hi Support, We first raised this problem/bug back in Feb 2022. It seems that the incremental rules are not working correctly. The client Xandor had removed these incremental rules from their Live system some time ago but re-introduced them this month, and have failed. The problem seems to be related to using multiple incremental rules e.g. 'MODIFIEDDATETIME > (Last Max Value) - 3600 seconds & TRANSDATE > (Last Max Value) - 15,552,000 seconds.  Please see attached document for further information on this. The client is currently on version 20.10.30.64 and have TX configured to use SSiS for data transfers.  Do you know if there is a solution to this issue please? Thanks,Kashif 

5
Christian Hauggaard
Community Manager
28 days ago

Badge winners

  • Certified Solutions Architect
    vrowsehas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    omarin23has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Marco_Bitmetrichas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    LarsBoyenhas earned the badge Certified Solutions Architect
  • Innovator
    anders.e.jonssonhas earned the badge Innovator
Show all badges
Terms and ConditionsCookie settings