TimeXtender Desktop Q&A

Hi. I aheba question for you all:   I have a table for example link this filed_name:Format Product_id: Integer Delivery_metod: varchar(50) Inventory_id: Integer Inventory_Entries: JSON   Inventory_entries can contain one or several entries in JSON format like this: [{"SKU":"A","Price":"100"},{"SKU":"B","Price":""00"}]   Instead off one line with the json entries nested into one single field i would like to Normalize the tabel into several lines, one for each SKU.   Any ideas?      

Example scenario: Table DimProject has 2 mappings, each from a different source: Mapping 1 = SourceA.Project Mapping 2 = SourceB.Project Now both systems will have the same project number with different meanings.   My question is how do I make a transformation that returns 'A' + [project number] in mapping 1 and 'B' + [project number] in mapping 2. The solution needs be rely on explicitly meaningful conditions, no implicit conditions that drive people crazy trying to decipher what they are for somewhere in the future. Any ideas?

Hello, one of several incremental tables won't execute. upon execution the transfer fails stating "invalid column name " & name of the incremental column. The problem occurred in Version 19.2.7.64 and is still present after an upgrade and redeployment to Version 19.11.7.64. What I tried so far. I tried to change the column from Incremntal_date to id. Redeployed the full table configuration. Upgraded to Version 19.11.7.64. Help is much appreciated.   Best regards Peter  

Just for anybody interested: I just found out that you just update the _I table to some older values, to reload all data greater than the value you set. Previously, I always reloaded the full table in these cases. This is not necessary and saves me some time from now on.

Hello, I have the following setup for an incrementally loaded table: I would expect, that it loads all rows, with either an id greater than max id - 1000 or datum_post greater than max datum_post - one week. In fact, when I execute the query, it is not returning any rows. This is interesting, because removing the datum_post condition returns rows. Other tables with such a double condition (id + date) also work. I am wondering, whether it is necessary to have an index on datum_post in the source table? The queries can take quite a while on the datum_post field. The example query takes 2 minutes on the source database, but TimeXtender finishes after 30 seconds. TimeXtender says it is finished with "Success", but there are no rows. Also the following query yields results when querying the source database directly:  I think this is the equivalent query to what TimeXtender should load. I am using Discovery Hub 19.6.7.64 and the source database is using (an old) mysql version:  I am conne

Is there any method for specifying encoding hints for SSAS in the semantic layer? If not, this could be useful and very easy to implement.  { "name": "Sales Amount", "dataType": "decimal", "sourceColumn": "SalesAmount", "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", "sourceProviderType": "Currency", "encodingHint": "Value" }

Hi,  i've setup a MDW layer with proper relations between tables. At this point I wanted to create a relation diagriam to visualise to my client the relation between his entities.  my tool of choice was SQL Management Studio. Only then i've realised that DH only create DW_Id as physical primary key and the relations between tables are managed internally   Is there a way in DH to visualize the relations between the tables?  I've already put my vote here https://support.timextender.com/hc/en-us/community/posts/360000924546-Relation-Diagram-based-on-total-layer?input_string=database%20diagram%3A%20visualize%20your%20data%20model  

Hello, Since a couple of days I created a second execution package to execute +- 10 tables, some dimension and 1 cube. After this execution the other cubes are not reachable, I need to deploy and execute them all to get it solved. Any clue why an execution pack would block access ? Thanks, Ronny

Hi, I am trying to build a transformation process in TX based on the following SQL code. ------------------------------------------ SELECT distinct[BusinessEntityID] ,B.MonthKey,[StartDate],[EndDate] ,[DepartmentName]FROM [TX_DSA].[dbo].[EmployeeDepartmentHistory] Ajoin dbo.Calendar B ON B.Date >= A.StartDate where b.DateValue >= a.StartDate AND (a.EndDate is null or a.EndDate <= b.DateValue) ---------------------------------------------------- I want intentionally to expand the grain of table A. I tried different Joins and conditional lookups but I just can't reproduce the output. How would you solve this? Thanks in advance grJose

I am joining 2 tables T1 and T2 based on a condition T1.A = T2.B T1.A have values like 'wNFq' and T2.B have values like 'WNFQ', 'wnfQ', 'WnFq', 'wNFq' For a regular join a particular row of 'wNFq' from T1 gets joined with all values: 'WNFQ', 'wnfQ','WnFq' and 'wNFq' of T2 My intention is to join only 'wNFq' from T1 to 'wNFq'. I achieved the same using custom SQL insert and using the below  COLLATE function to join based on case sensitive sequencing using: T1.A COLLATE Latin1_General_CS_AS_KS_WS = T2.B COLLATE Latin_1_General_CS_AS_KS_WS Wandering if there is a different way to achieve this avoiding custom SQL. Appreciate any help on the same.  

Created a conditional lookup based on following : T1 joined to T2 where T1.A = T2.B Looked up T2.C based on the above join condition and stored the value in T1.D Now I need to filter the resultant data set which is on T1 based on certain values of T1.D Unable to put that filter in the Table Data Selection Rule. Even I tried to copy T1.D(look up filed) to T1.E (a separate filed created just to hold the value of T1.D) and filter on T1.E, even that did not work. Appreciate help on the same.

I have the following set of tables: A (key1, key2) B (key2, key3) In that case, every key1 can have multiple key2 attributes in table A and every key2 can have multiple key3 attribues in table B. When I would use a conditional lookup field for table A to get key3, it would only give me one of the key3 attribues, is it possible to take all values? I know I could do it with a simple custom view left joining on key2, but is there are recommended way to do it in Discovery Hub without custom views? So the goal table should be like C (key1, key2, key3)

Dear TimeXtender's Team, What is choice to setting rounding in TimeXtender if we want to set up decimal ?  Like example .. in Original Data is $12,3456, we just want the result is $12,34 (2 decimal) because in TX, it will be $12,35 Thank you,

Hello! I'm trying to resolve an issue where OLAP fails to execute during ETL processing due to a canceled transaction attempting to acquire a lock.  This is occurring on a QA instance hosted on a dedicated server that doesn't have any other ETL jobs processing.  I'm seeing a pattern of failures occurring on particular days of the week.  However, the error message sent in the ETL email isn't specific to the root-cause.  Also, I've perused 3 online resources that give explanations on the causes and remedies for such an issue, as I've gained understanding thereby that this matter occurs due to insufficient "timeout" settings.  But those tactical solutions pertain to remediation via the traditional SSAS development capacity, and such do not apply to the TX DWA software  For I don't see a way within TX DWA to change the settings for CommitTimeout and ForcedCommitTimeout.  Does anyone have any insight on how to rectify this issue? Your input would be greatly appreciated.  Thanks and have a g

We've upgraded to enterprise edition for the MS SQL server product hosting the cubes. I have noticed a tick mark when editing cubes that says "Incremental load" - and I realise this is an Enterprise edition feature of SSAS. Is anything else required to "make it work" other than ticking this tick mark? What does it actually do? Does it also speed up the dimensions processing or "just" the cubes?

Hi.    I have made a Qlik and defined the relations between the different tables. Now i have a change to the relation, but i cannot update the relation in the Qlik model?   The only way is to remove the tabel, deploy and insert it once more into the Qlik model.   Am i doing something wrong?   Version 17.12.64

I'm trying to create a hierarchy of GL accounts and the category they belong to. (i.e. Assets, Liabilities, Equity, Income Expenses).However the Hierarchy is displaying alphabetically.  If it were to be sorted by the first GL account it's associated with, it would sort correctly since GL accounts are numbered in the proper sequence.However, when I tell the Dimension, "Parent Category" (which is the Assets, Liabilities etc) to sort by Attribute Key, when I deploy I get an error saying it can't be used as an attribute because it is not related.Is there a workaround to this?

 Hi I 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? 

Is there a way to customize the error text so that in the log it will read something other than "Field X does not comply with validation rule y"

  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?  

HI  I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.

Hi, I have a source table in Navision which contains inventory data. The data is sometimes changed back in time due to miscellaneous reasons. I have sofar handled this with change tracking in Sql Server and then I do a merge statement that either inserts new data or does an update on older data already in the fact table.  So my question is how could I handle this in TX and do a inceremental load?   Regards Birkir

Hi all I recently changed the environment properties of the development environment to have the AX data source point to the live environment instead of the test environment. I hoped that executing (without deploying) the staging area would refill all staging tables with live data instead of test data (all full loads, no incrementals), but it didn't. In fact, what needs to be done, is deploying by manually marking all tables to be redeployed in the deployment screen, as nothing has changed according to TimeXtender. Is it possible to make the SSIS package connections dynamically looking at the environment properties (this way an execute would suffice)? Or mark the staging tables to be redeployed? TimeXtender version 16.8.1.64; project is using SSIS. Thanks!

I can see the custom data on the table when I go and check advanaced. How to know where does it exactly points to? I am trying to find the location and file name of the excel sheet I loaded.