Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

722 Topics
R
Starter
richardrayStarter
asked in Prepare
Troubleshooting data cleansing rules

v20.10.36.64Hi,I have a project that is loading data from the ledger table into the staging database with approx, 5m records.When manually executing the load, the ADO.NET transfer is taking 5-6 minutes, but the cleansing rules can take hours, to the point I have to terminate the load.Is there any troubleshooting I can perform on the cleansing steps? I know I have taken the easy option on joins where the data types differ, and wonder if that is now compounding the issue?Any tips or pointers greatly appreciated.Thanks,Richard

4542
R
Starter
L
Contributor
LorenzoContributor
asked in Prepare
Range lookup

Hi,I would like to do a “range lookup”. Because I can't solve it using a conditional lookup, I used a custom field transformation. My code looks like this:CASE    WHEN substring([SBIcode_cleansed], 1, 1) like '[^0-9]' THEN                    (SELECT [kvk_groep_omschrijving]                     FROM  [dsa].[SBIcode_groepering]                             where [SBIcode] = [SBIcode_cleansed]                   ) --'test1'   ELSE                   (SELECT [kvk_groep_omschrijving]                     FROM  [dsa].[SBIcode_groepering]                            where substring([SBIcode_cleansed], 1, 2) >= [min_sbi_code]                              and substring([SBIcode_cleansed], 1, 2) <= [max_sbi_code]                   )--'test2'   END It seems that a subquery is not possible because I get an error message that more than one value is retrieved using the subquery but that is not possible.Testing it in SSMS works fine. (Not using between because above seems to work faster when testing

1416
rory.smith
TimeXtender Xpert
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Deliver
Incremental refresh for XMLA Power Bi semantic models

Until I have started using TX, I am setting up my PBI import datasets using incremental update as you can see in:https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overviewNow, in TX, how can this be accomplished?

2678
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Prepare
Adding a new field to an existing table with data

If you add a new field with the deploy only option, to an existing table with data, there are two diferent behaviors, depending if the table has incremental rule defined or not.This is controled by this setting: By default it’s cleared for “normal” tables and setted to incremental tables.I think the behavior should always be the same or at least get a warning message

330
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Partition Schemas

I’ve detected that if you have the same table in DSA and MDW. let say DSA.Invoices and MDW.Invoices for example, and you define partition for that, both tables share the same partition schemas and partition functions in the SQL Server database.It’s a problem when you try to add or remove field from whatever table.

1118
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Jobs & Executions
Execution Logs

When I launch a job directly with the Execute menu option, I get several lines in the execution log without information to know what it is.  

941
Christian Hauggaard
Community Manager
Jan Stroeve
Contributor
Jan StroeveContributor
asked in Ingest
CSV source loads all fields as bigint

I have created a CSV source in Timextender NG ODX.  The data explorer shows the data type correctly for my table.However, when I drag the table to the DSA, all fields appear as bigint type. (by the way, I have setQuote Character to “  and Row Scan Depth to 0). Any help on how to resolve this issue, would be appreciated.

1317
Christian Hauggaard
Community Manager
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Prepare
Replace transformation with char type requires looking up the int value of a char

I discovered that when using the replace transformation with the CharType that you are required to know or look up the int value of the character you want to replace and use that as the parameter.This does not seem to be documented anywhere or be useful in any way I can think of. I assume REPLACE('abc’, char(65), 'b’) is functionally equivalent to REPLACE('abc’, 'a’, 'b’). In a Case Insensitive collation there is no difference between the two anyhow.There is also no COLLATION or binary type support, which are things that you can do with REPLACE() that might actually be useful in certain rare cases. 

1695
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Deliver
Custom Fields in Semantic Models

I’ve created a custom field in a semantic model table:  But in PBI using a Mixed storage model, it doesn’t works, but if I create the column directly in PBI desktop, it works:  

1105
Christian Hauggaard
Community Manager
T
Participant
thzmanParticipant
asked in Ingest
ODX API version error

Hi!We have had our installation for a while now but as far as I’m aware the application has the latest updates. As we are becoming more people in the project working at the same time I have installed the client on both a new server and on my own laptop. The problem is that when I try to connect to the ODX service running on one of our “old” servers I keep getting the error as in the attached pictures. Why is this? As you can see the application has the same version on both thte “old” and the “new” server.The correct ports are opened between the servers at least so that should not be an issue but I get the same error when trying to connect from my laptop. Anyone who has an input on this? 

1113
T
Participant
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Problems with "Manage Query Tables"

I’ve a query table created to my D365 F&O data source like you can see in this screenshot: The query returns data as you can see in the query tool (it would be nice to be able to run it in the “Manage Query Tables” window too): But, If try to Synchronize ODX Objects: I get an error and there is not the table if I try to remap it:  And when I deploy and execute the table, it’s empty: Is this a bug or I’m doing something wrong?

1232
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Jobs & Executions
Job definiton

Something it’s missing in this phrase:  

552
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Jobs & Executions
View the Execution Log

As you can see in the next screenshots, the “View execution log” feature doesn’t works correctly: 

512
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Deliver
Development, Test and Production environments combining with PBI deployment pipelines

The use of PBI semantic models require to use XMLA endpoint, that’s mean that we need a Power Bi PPU license. That it’s ok.The question it’s why not use the deployment pipelines feature in PBI PPU?The principal problem that I found it’s that it’s not possible to parametrize the data source conections to use correctly this feature.Somebody has experience in this topic?

803
rvgfox
Problem Solver
M
Starter
malose.motlhasediStarter
asked in Prepare
SQL Server Analysis Services Error

Greetings,I have an odd error and trying to eliminate where this issue is coming from.I have a server running SQL server 2016 and TX is running on top of that. The version of TX I am running is 20.10.15.64 in Server 1.The errors I am getting are attached. TX is running ok in Server 1 which is DB server.There is Analysis Server 2 which seems to be an issue and is creating the errors above.The attached error is coming from PowerBI Report Server interface. We are using Microsoft PowerBI tool for our reports. I have increased memory allocation in Server 1 where TX is running and issue seems to still be there.Our products are all 64bit version.Any Idea or view of what could be causing this.  

3685
M
Starter
S
Contributor
sguntupalliContributor
asked in Ingest
Selecting provider

I am using the 20.10.36.64 desktop version.I am trying to select a provider to connect the SQL server using ODX.I am not seeing any SQL-specific providers here.Which one should I use?  

221
rvgfox
Problem Solver
A
Contributor
alain.thireContributor
asked in Ingest
Error connecting to DB2

Trying to connect to DB2 sql server  with 20.10.6.64 but get an error  (NO error message available) that is not documented. Connection is working in another environment. It is not the CDATA connector but DB2 from data source

271
A
Contributor
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in Prepare
Object Security for Raw table (_R)

Hi, Is it possible to add object security rules on a _R table from within TimeXtender?  Thx! 

584
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Prepare
Data platform with TimeXtender data architecture

I would like to share with you this diagram that shows the architecture of our data platform with TX.Perhaps it will be another recomended architectures and I would like to know it and start a discussion about this topic.  

410
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Deliver
Role play dimensions

In the semantic model design it’s very common the need to implement role play dimensions.Do you have some guidines about this?

621
ShivamKapoor
Employee
M
Starter
MarcoJStarter
asked in Prepare
How to remove tables from a MDW

When I remove a MDW-table from the project it remains available in the MDW-database.How do I completely remove the table so I can start over (create a new table using the old name)

862
M
Starter
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Prepare
Currency conversion

We are implementing a data warehouse with data from Dynamics 365 F&O and I’m thinking that we will have money data from UK in pounds and from Spain in euros and we will need currency conversion (based on time) to resolve this situation.Some body has considered this situation?How must it be implemented? 

651
Thomas Lind
Community Manager
hugo.winkelhorst
Participant
hugo.winkelhorstParticipant
asked in Ingest
Amazon Redshift Connector SSL mode drop down missing options

For one of our clients I need to connect to a database on Amazon Redshift. The IT Vendor who made the system is telling us to use SSL mode Required ( https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-ssl-support.html#connect-using-ssl ). Using this setting in the ODBC connector from Amazon itself works fine but the CData connector only gives a true false dropdown. I've checked if this perhaps was one of those fields where you can overrule the drop down with manual input but that's not the case for this one. Is there any way to get this working in the CData connector or would our only option for now by create DSN and then use the ADO ODBC option the the ODX to connect with the DSN.

1177
hugo.winkelhorst
Participant
Peter Dijkstra
Starter
Peter DijkstraStarter
asked in Prepare
Data selection rule is not working with Mapping Sets

If i try to add a dataselection rule my tables stay empty.Tried allready the selection rule on the table and with an without ‘ ‘ If i do the same in the query tool it looks good. Is it a bug?Using version 6143.1

23813
Thomas Lind
Community Manager
M
Explorer
mchinskyExplorer
asked in Prepare
Execution Row Count

After manually executing a package, where do I find a log that shows the # of rows processed per table?  I'm trying to verify my incremental loads are working properly

1323
Christian Hauggaard
Community Manager

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
Terms and ConditionsCookie settings