To homepage To homepage

Semantic Models

Ask questions about TimeXtender Semantic Models Instances

  • 53 Topics
  • 229 Replies

53 Topics

andrew.gebhard
Participant
andrew.gebhardParticipant
asked in Semantic Models

Incorrect syntax for parameters on custom fields in Qlik semantic models

Hi team, TimeXtender allows adding parameters from a different table to a custom field in a semantic data model (Qlik). The resulting syntax/qlik script combination is always broken.When using adding a custom field parameter from a different table, TimeXtender fully qualifies the Qlik syntax regardless of the settings. The resulting syntax on the Qlik side will no longer match the syntax in the views created by TimeXtender:Qualified setting:Fully qualified setting: The resulting Qlik Script:"Sales_Targets":LOAD"KPI", "Target", "DIM_Boekdatum.DayName" AS "Test";SQL SELECT"KPI", "Target"FROM "Test"."dbo"."Test QVD_SLQV";But the view has the following syntax:CREATE VIEW [dbo].[Test QVD_SLQV]-- Copyright 2011 timeXtender a/s-- All rights reserved---- This code is made available exclusively as an integral part of-- timeXtender. You may not make any other use of it and-- you may not redistribute it without the written permission of-- timeXtender a/s.ASSELECT [KPI] AS [KPI] ,[Target] AS [Targ

7
Christian Hauggaard
Community Manager
8 months ago
amartinez
Starter
amartinezStarter
asked in Semantic Models

TimeXtender 20.10 Semantic Layer Export

We are facing an issue with one of our clients in which we built out a UAT environment to promote proper development but have come across an issue where we have a fully built TX Semantic Layer on the production environment, but we do not have it built out for the TX UAT environment. The reason behind this was because the test Qlik Sense environment was not available initially, and we could not successfully execute packages on the TX uat environment, so we decided to work without it on TX uat. Now that we have an operational test Qlik Sense environment, we want to export the semantic layer from TX production to TX uat environment. Is there a way for us to do this in TimeXtender? We are trying to avoid large amount of manual work to build this out on the TX uat environment and we dont want to export project from Prod to UAT as that will override all our work in UAT environment. Prod TX Semantic LayerUAT TX Semantic Layer  

3
amartinez
Starter
8 months ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Semantic Models

Recomended data types for numeric in semantic models

When we creating a numeric field in a MDW table, TX suggets use a numeric(38,6) for the data type.When the field it’s translated to the semantic model it’s detected in TX:But in the model:And one of the best practice rules says “Do not use floating point data types”.How can I follow this rule?   

7
rory.smith
TimeXtender Xpert
9 months ago
R
Starter
ronald.vankoutrikStarter
asked in Semantic Models

Combine two Row Level Security columns on Fact within Tabular Cube model with AND instead of OR?

Dear Reader,Dynamic Row Level Security (DRLS) can be implemented by defining a table that contains 1. values for the column to be secured; 2. defining the users email-addresses.With this specific case, two DRLS columns are defined.This is shown as depicted in the first picture below:The first column (_Retailer_Key).The second column to be secured is also dynamically defined (_CountryAccess_Key):This works, however suppose I have 4 retailer country combinationsCountry Retailer UK YourOwn NL YourOwn UK Theirs GE Unsere  And the _CountryAccess_Key that was defined by DRLS was “UK” and the Retailer was YourOwn, then the Result is that the rows with the red font is returned. This is just (_CountryAccess_Key OR _Retailer_Key). However that’s not the result required. The result should be (_CountryAccess_Key AND _Retailer_Key) as depicted below.Now the result only returns one row (depicted in the red font) Country Retailer UK YourOwn NL YourOwn UK Theirs GE Unsere

4
R
Starter
1 year ago
R
Explorer
Rasmus HøholtExplorer
asked in Semantic Models

Deployment of semantic model in multiple enviroments

Hi,I have created a semantic model in our development environment with a global database,In development the model is named Sales DEV and in production it is named Sales.When I make changes to the model and do a multiple environment transfer, the data in the production model is deleted and the users cannot use the model before I have executed the model in the production environment.I expected a creation of a offline model, which could be executed at a later time. Instead our users cannot access data in a period of time, which is unacceptable to our business.How can I avoid this, so our users do not experience down time on the production model? Kind regards,Rasmus Høholt

18
R
Explorer
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Semantic Models

Setup CSV endpoint to Blob storage

Is it possible to use CSV endpoint to Blob storage?How can I setup it?

4
rory.smith
TimeXtender Xpert
1 year ago
M
Starter
malknStarter
asked in Semantic Models

Multiple semantic layers

We using multiple semantic layers, and adding more in the future. All semantic layers will probably need a calendar dimension and some other dimensions are also shared between layers. Is there any 10x  method to copying between semantic layers, as it seems quite ineffective to setup:sort bysummarize bycategoryn-times on the same table

1
Thomas Lind
Community Manager
1 year ago
L
Contributor
LorenzoContributor
asked in Semantic Models

Change schema in Data Export

Hi,The current Data warehouse has tables with two different DB schema's. There are already PowerBI Dash-boards using these schema's. Now I want to use the Semantic layer to copy the data (Data Export) to a SQL serverless DB. Everything works fine but I want to override the schema name. In the Semantic layer I have not find any options to change this. Is that correct or is there a way like in the Dataware house layer to change the schema?

3
Christian Hauggaard
Community Manager
1 year ago
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Semantic Models

Qlik Sense Enterprise endpoint cannot create/modify a Data Connection

TX: 20.10.39SQL Server: 2019Endpoint settings:Windows authentication hostname matching case https connection over the default proxy I am trying to push a Qlik Sense Enterprise endpoint from TimeXtender and having trouble getting the deploy successfully running. Testing connection to Qlik Sense is successful, when I Deploy I get an error when TX tries to create a new Data Connection. I see this issue pop up sometimes in other deployments and can usually overcome by manually making a Data Connection to the MDW database and giving it the same name TX would use: MDW_SLQV . In this case, I get the same error when TX tries to modify the connection.TimeXtender does create the app (and is owner of it) and can successfully reload the app, it just doesn't insert the script. If I copy-paste the TX Qlik Script into the app it works fine. As neither TX nor Qlik actually log what is going on, I cannot see what about the connection string is causing the error.

9
Christian Hauggaard
Community Manager
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Semantic Models

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?

8
rvgfox
Problem Solver
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Semantic Models

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:  

5
Christian Hauggaard
Community Manager
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Semantic Models

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?

3
rvgfox
Problem Solver
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Semantic Models

Some custom measures in PBI semantic models doesn't works

I’ve detect that some dax code doesn’t works in PBI.Are there some guide abut this? 

11
Christian Hauggaard
Community Manager
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Semantic Models

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?

1
ShivamKapoor
Employee
1 year ago
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Semantic Models

Wrong definition of measures in semantic models

Whwn you define a measure, like a Sum: The internal DAX expresion it’s wrong (but it works) as you can see with tabular editor: 

2
Christian Hauggaard
Community Manager
1 year ago
M
Explorer
mark.beedleExplorer
asked in Semantic Models

Partitioning and Execution in SSAS Tabular

It would be really beneficial if functionality was added to the Semantic layer, such that SSAS Tabular partitions could be defined within the tool.Ideally, one would be able to right click on a table within the semantic model and choose partitioning, which would allow you to pick a field, like a Date field and configure it so that partitions on say Year, or Quarter, or Month, or Week would be dynamically created with each deployment of the tabular model. Additionally, it would also be great if once TX had visibility of the metadata of the partitions it has created, it would be extremely beneficial if we could then decide which partitions are executed in a given execution package.A little background for this request, we are in the middle of a major AX and data warehouse project, and we are building out quite a few SSAS tabular models to be consumed by Power BI.  Unfortunately, with the current setup of the semantic layer, we are having to consider managing tabular models outside of Time

4
Christian Hauggaard
Community Manager
1 year ago
V
Visitor
vance.nicholsVisitor
asked in Semantic Models

OLAP ETL failure Issue

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

1
Christian Hauggaard
Community Manager
1 year ago
F
Visitor
fredrik.juelhagenVisitor
asked in Semantic Models

Encoding Hints in semantic layer

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" }

1
Christian Hauggaard
Community Manager
1 year ago
M
Contributor
Michel van DrunenContributor
asked in Semantic Models

Error during deployment semantic layer azure analysis services

Hi,During deployment of the semantic model in TimeXtender 6024.1 an error occured.Finished executing instance 'SSL Test' Execution Package 'Execution Queue Default'Execution failedStart Time : 1/10/2023 12:05:34 PM End Time : 1/10/2023 12:05:36 PM on server: vm-tx-prod-01-Execute Execution Package Execution Queue Default 'Failed'    Object reference not set to an instance of an object.        Details:        Object reference not set to an instance of an object.    Module: TimeXtender.Semantic.Logic    System.NullReferenceException       at TimeXtender.Semantic.TOMEndpointDeployExecute.GetColumn(SharedSemanticLayerField field, Table parentTable, SharedSemanticLayerEndpointTOM endpointTOM, Dictionary`2 columnCache)       at TimeXtender.Semantic.TOMEndpointDeployExecute.CreateModel(SharedSemanticLayerEndpointTOM endpointModel, Boolean isDeployment, Boolean forCheckSum)       at TimeXtender.Semantic.TOMEndpointDeployExecute.Execute(SharedSemanticLayerEndpointTOM endpointModel)       at Tim

1
Christian Hauggaard
Community Manager
1 year ago
B
Starter
ben.vd.helmStarter
asked in Semantic Models

Data export in batch size

Currently we are facing a problem with memory resources when we're trying to do a data export. When writing a huge file, 4 gb, the memory allocated to this TX process takes up more resources than  we would like (> 22gb of RAM). Is there any possibility for breaking up the data export in partions, such that the process takes up less RAM? I would think there would be some kind of option like the data batch cleansing in the table settings, but I can't seem to find it anywhere.   Within the data export we use the TimeXtender File Export 2.0.0.0 provider. 

3
Thomas Lind
Community Manager
3 years ago
S
Visitor
stuart.bramallVisitor
asked in Semantic Models

Creating a many to many relationships in a tabular model

Is there a way to create a many to many relationship in the Tabular model.I have one tableDataWith Fields Project , Amount I then have a project Device TableWith fields Project, Devicee.g. A, 1A,2A,3B,1B,2 I then have a project tableWith fields Project And a device tableWith fields device The issue is I want to see the data table by device and project. The main data table contains 32 millions records and the project device table contains 10,000 combinations  so a workaround by creating a new fact table by creating a full outer join on the two tables might be a little inefficient , thanks

1
JTreadwell
Employee
2 years ago
B
Starter
bkleinStarter
asked in Semantic Models

Using TimeXtender with Tableau - which endpoint

Hi all, We recently started developing a new data platform using TimeXtender with Tableau as a visualization tool. We are currently determining how to setup our endpoint in TimeXtender for Tableau as we have several options, each with their pro's and con's. Im wondering what choice others made and if maybe there's something we haven't thought about yet while trying to make this choice. As we see it now we have three main options: - Multiple .tds files, one for each fact table. As Tableau requires all tables to have a relation with eachother it is not possible to have a .tds file endpoint with all facts as not all facts relate to all dimensions. Pro's: smaller, efficient sources with good manageable security. Cons: Can become difficult to maintain with lots of .tds which share dimensions, for example when an attribute is added to a dimension this has to be done multiple times. When using multiple .tds sources in a Tableau sheet there's no way to link shared dimensions and thus fltering

2
B
Starter
2 years ago
M
Explorer
mads.nielsenExplorer
asked in Semantic Models

DAX Studio

Hi Is it possible to use DAX Studio og Tabular Editor on Semantic models?Regards Mads

2
M
Explorer
1 year ago
M
Explorer
mads.nielsenExplorer
asked in Semantic Models

Composite models

Is it possible to or are there any limitation on using composite models in PowerBI in unison with the Semantic model created on TX? Regards Mads 

1
Thomas Lind
Community Manager
1 year ago
E
Starter
erwin.dekreukStarter
asked in Semantic Models

Could not connect to the Tabular server.

Getting the following error while connect to AASCould not connect to the Tabular server.Could not load file or assembly 'Microsoft.AnalysisServices.Tabular, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.Is there a way to solve this?

2
M
Starter
4 years ago

Badge winners

Show all badges
Terms and ConditionsCookie settings