To homepage To homepage
Solved

No perspectives when deploying tabular model

  • 21 September 2023
  • 14 replies
  • 152 views
R
Rank
Userlevel 2
  • RLB
  • Participant
  • 37 replies

I've made a simple semantic model and configured an Analysis Services (Tabluar) endpoint in Azure. There is one perspecive containing a few fields and measures. The model deploys and executes without any issues.
However, the perspective is not visible when connecting to the model from Power BI Desktop. Also, when I connect to the model from Management Studio, I can only browse the whole cube and again the perspective is not there. I can script the AS database to a new query window and the perspective is not mentioned in the script.

Is this an issue with TimeXtender? Or as AAS config issue perhaps? I'm using a PPU license but I don't think that's relevant since the perspective cannot be used in Management Studio either.

TimeXtender version is 20.10.37.64.

Thanks!

icon

Best answer by bas.hopstaken 22 September 2023, 08:51

View original

14 replies

daniel
Rank
Userlevel 4
Badge +5

Dear @RLB ,

To my knowledge a perspective is a TimeXtender funtionality. When creating a perspective this contains the whole SSAS cube and not parts of it. Having a perspective in your Semantic layer will not be transferred to the SSAS Cube.

What do you need the perspective in the cube for? I believe if you need to create subgroups within you SSAS Cube you can use the Display folders.

 

R
Rank
Userlevel 2

Thanks for your reply. I’m referring to cube perspectives as mentioned here: 

 and here. 

The goal is to have only one semantic model (instead of serveral, which has its own problems like having to create several versions of the same objects like time dimensions) and to define subsets of the model to be used by end users.

I don't think that can be accomplished by using display folders, but I will look into that.

 

daniel
Rank
Userlevel 4
Badge +5

Dear @RLB ,

 

Check! I see now. Have not used that feature yet. The display folders will not do what you want.
If the cube perspectives do not work, wait for @Thomas Lind or @Christian Hauggaard to reply.

Please ignore my previous comment :)

 

= Daniel 

R
Rank
Userlevel 2

No problem! Thanks again.

The thing is, I've been using cube perspecitves in the SSAS multi dimensional model for twenty years and it's somehting I'm not preparted to give up… yet :)

rory.smith
Rank
Userlevel 5
Badge +7

Hi @RLB,

 

A SSL perspective is not a Tabular model perspective. TimeXtender allows you to have very large models which you can then organize using TX SSL Perspectives, but this is only used in the TimeXtender context.

(Azure) Analysis Services and Power BI Premium Capacity also have their own perspectives (see: https://learn.microsoft.com/en-us/analysis-services/tabular-models/perspectives-ssas-tabular?view=asallproducts-allversions) which also allow for deeper technical possibilities, but you cannot generate those from TimeXtender

R
Rank
Userlevel 2

I'm confused, because @Christian Hauggaard seems to say otherwise:

Except he's using the new version of TimeXtender.

rory.smith
Rank
Userlevel 5
Badge +7

Isn't he using SSAS Multidimensional (OLAP) as opposed to Tabular (SSAS / AAS)? If you are using AAS you only have access to Tabular. If you want Multidimensional you need a VM-based SQL Server with SSAS.

For the partial reload part there are (old) Ideas which could be upvoted. This idea also contains some Powershell options if you are using PBI Premium Capacity: 

 

daniel
Rank
Userlevel 4
Badge +5

I believe that there is a difference between the Multidimension SSAS and the Tabular SSAS and that might be why the Perspective is not working?

R
Rank
Userlevel 2

I’m not sure. It says Note: Perspectives apply to Tabular endpoints only right at the top of the page. And I don't think a Multidimensional endpoint even exists? In my opinion I’m just trying to accomplish something that is basic AAS functionality.

Also, why is the Manage Perspectives window even there if it cannot actually be used?

R
Rank
Userlevel 2

I believe that there is a difference between the Multidimension SSAS and the Tabular SSAS and that might be why the Perspective is not working?

That is true, but SSAS Multidimensional is used differently in TimeXtender. It is part of the semantic layer, but it's not used as an endpoint connected to a semantic model. It's a separate thing.

R
Rank
Userlevel 2

Apologies, this should have been posted in the Legacy board I think.

bas.hopstaken
Rank
Userlevel 3
Badge +4

Hi @RLB ,

It depends on the AAS Pricing Tier you are using. According to this link: https://azure.microsoft.com/en-us/pricing/details/analysis-services/, it is only avaliable in the Developer and Standard pricing tiers.

A While ago I was able to get it working correctly using the AAS Standard Pricing Tier.

 

 

Bas Hopstaken (2Foqus)
bas.hopstaken
Rank
Userlevel 3
Badge +4

@RLB ,

Please be aware that upgrading from Basic Pricing Tier to Standard is a one-way action. This can not be changed back to Basic.

 

 

Bas Hopstaken (2Foqus)
R
Rank
Userlevel 2

Thanks @bas.hopstaken! I can't believe I wasn't able to figure that out myself! You're right, we're on the B2 tier.

Also some of the other answers were a bit confusing to be honest ;)

Reply


Terms and ConditionsCookie settings