To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
Legacy

Home
Community overview
TimeXtender Desktop Q&A
Semantic Models

Semantic Models

Ask questions about TimeXtender Semantic Models Instances

27 Topics
103 Replies

When you subscribe we will email you when there is a new topic in this category

27 Topics

Recently active

Most replies Most views Newest first

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

5 days ago

rvgfoxContributor

asked in Semantic Models

Dynamic role security setup values not reselected on edit

In this screen:It’s not possible to delete a member. The only way it’s delete the “RLS Setup” and create it again. It’s crazy.. Another crazy situation it’s that if you define a Dynamic RLS Setup and press ok and enter to to see it, it’s lost...

1 month ago

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

2 months ago

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

2 months ago

rvgfoxContributor

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?

2 months ago

malknVisitor

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

2 months ago

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 months ago

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.

3 months ago

rvgfoxContributor

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?

3 months ago

rvgfoxContributor

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:

3 months ago

rvgfoxContributor

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 months ago

rvgfoxContributor

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?

3 months ago

rvgfoxContributor

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?

3 months ago

rvgfoxContributor

asked in Semantic Models

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

1 year ago

mads.nielsenExplorer

asked in Semantic Models

DAX Studio

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

1 year ago

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 year ago

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?

3 years ago

mads.gratheStarter

asked in Semantic Models

Semantic Models with no Endpoint

Is it not possible to create a semantic model with no endpoint? For me, the beauty of the semantic models is that I can quickly create views for 'data marts' where I can do data selection rules without having to write a single line of code. In previous versions of TX I could use the Qlik (Deprecated) semantic model for this because it didn't need an endpoint in order to deploy the views. But the newest version(s) of TX does not support this. So what if I'm moving entire corporation's data visualizations to Qlik SaaS (basically Qlik Sense in the cloud)? Can I no longer use semantic models?

2 years ago

Page 1 / 2

Badge winners

ParcifalVGhas earned the badge Certified Solutions Architect
rasmusgadensgaardhas earned the badge Certified Solutions Architect
JensFylkissonhas earned the badge Certified Solutions Architect
f_keferhas earned the badge Certified Solutions Architect
kerry_bespokehas earned the badge Certified Solutions Architect

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.