Skip to main content

Semantic Models

-

  • 18 Topics
  • 22 Replies
18 Topics
M
mads.nielsenNew Participant
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 

11
T
M
mads.nielsenNew Participant
asked in Semantic Models
DAX Studio

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

12
M
B
bkleinNew Participant
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

02
B
M
mark.beedleParticipating Frequently
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

03
V
S
stuart.bramallNew Participant
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

11
J
K
krdNew Participant
asked in Semantic Models
Calculated measure Standard Deviation

I have a calculated measure that is the the total lead time from when we order a good at a supplier, until it has been received and inbounded.  Now I would like to calculate the standard deviation of the lead time. But I can't seem to get it working, what is missing?

10
K
G
greg.laymonNew Participant
asked in Semantic Models
Automating Data Export to generate a file per value in value in control table

Essentially, I am currently creating csv files from extracts of many TimeXtender tables.  Let suppose the data in a table is a column which identifies each row by country and the table contains many rows for each country, then I would need to create a file for each ISO country that existed in the table.  I know how to do this by hand, but am wondering if there is a clever way of automating this in TX without having to build an SSIS package? Thank, Greg  

01
J
M
martin.d.larssonKnown Participant
asked in Semantic Models
Error while processing SSAS Tabular cube

I am able to deploy the semantic model but when I execute it I get the following error message: The current operation was cancelled because another operation in the transaction failed. Details: The current operation was cancelled because another operation in the transaction failed.System.Exception Not much do work with Im sorry to say but this is what I get. This is the TXDictionary project and it has worked before i moved it to a new server. The rest of the project executes fine (ODX, DSA and MDW).

23
M
M
mads.gratheNew Participant
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? 

02
M
M
mark.beedleParticipating Frequently
asked in Semantic Models
Differential Deployment - SSAS Tabular

It would be ideal if we could use differential deployment in the semantic layer, particularly in SSAS Tabular, or at least choose which table I want to deploy, as opposed to deploying the whole model.   If I make a change to the DAX of a single measure of a 5 gb tabular model, it is less than ideal to then deploy the entire database and process full, just to see the effect of the DAX measure in a front end tool.   Developing SSAS tabular seems to be quicker and easier in VS because of this feature.

11
A
M
martin.d.larssonKnown Participant
asked in Semantic Models
TXDictioanry from CubeStore error on Execute

I just tried the TXDictionary project from CubeStore and managed to deploy the ODX (Business Unit) but when I start execution I get the following error: Invalid object name 'etl.ExecutionPackageLogs_I'.   Running TX 20.10.1.64

11
T
B
ben.vd.helmNew Participant
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. 

33
T
F
fredrik.juelhagenNew Participant
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" }

00
F
V
vance.nicholsNew Participant
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

00
V
R
rrnNew Participant
asked in Semantic Models
SQL Server Enterprise - incremental load on cubes

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?

00
R
M
mikkel.hansenNew Participant
asked in Semantic Models
Cannot update relations in a Qlik Model

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

00
M
J
jyothi.dosiNew Participant
asked in Semantic Models
Convert decimal to whole number (Cube measure)

 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? 

01
T
M
martin.oloughlinNew Participant
asked in Semantic Models
cube filtering

  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?  

01
J

Badge winners

Show all badges
Terms & ConditionsCookie settings