Azure Analysis Services
Do you have an idea or suggestion based on your experience with Analysis Services? We would love to hear from you! Please take a few minutes to submit your idea, or vote up an idea submitted by another customer. All the feedback you share in these forums will be monitored and reviewed by the Analysis Services engineering team. By suggesting or voting for ideas here, you will be among the first to know when it gets done.
Please remember this is only for feature suggestions and ideas! If you have technical questions, please submit a question to our MSDN forum. Azure Analysis Services shares the forum with SQL Server Analysis Services due to same modeling, management tools, etc.
If you need support, please open a support ticket through the Azure Portal.
-
Allow to change the service account
As a best practice, we'd typically use Windows auth for on-prem SSAS where the SSAS service account is granted access to the data source to process the model. Allow us to change the Azure AS service account to be used when processing from SQL Server.
6 votes -
Create a "metadata" model.bim template that can target a specific Analysis Services database
Business users and report-writers that interface with the tabular model often have many questions about what the relationships between tables are, what the specific measure definitions are, or just want to know general description information about the model.
While I can create a generic "metadata" model myself that connects to a targeted AS database's DMVs, it'd be nice if Microsoft created a standard template as a model.bim file and published it so that we can very easily edit the datasource to select our targeted model.
6 votes -
Tabular model KPI status thresholds using fields
We should be able to set the KPI status thresholds using table fields or measures. In my business KPI thresholds change with seasons and item categories. So by being able to set these thresholds using table fields or measures, the thresholds can be set without having to edit the datamodel.
6 votes -
5 votes
-
5 votes
-
Improve the error logging when Visual Studio crashes
It's not always easy to re-produce a crash in SSDT, and at times it can feel like the crash was due to typing out a measure too quickly, coming up with wacky m queries, or perhaps even because it is too windy outside. An improved error log would at least give me some solace that SSDT isn't prejudicing my model development due to my taste in music.
5 votes -
Highly Available Azure Cubes
I would like to see a feature in Azure analysis service where when if a server or cube is getting processed the report connection can be redirected to another server. This functionality can be done in on premise cubes with help of load balancer and shell scripts. Anything of this sort on Azure can be great full.
5 votes -
"Overdraft Protection" for Memory Consumption
Similar to overdraft protection on a bank account... would be nice to have a similar concept for Azure AS instances where the instance auto-scales up if memory consumption exceeds the current limit (instead of an error - for example during processing)
5 votes -
Diagram lacks functionality
If you compare the Diagram functionality withing Tabular Analysis Services to Dimensional Analysis Services, the tabular one is too simple.
The dimensional one has a possiblity to create "layers" or views which can reduce the complexity.Please make it possible that
- You can create multiple diagrams within Tabular AS.
- You can save those diagrams within the BIM file.
- When you create an ASDDatbase file, it should contain those diagrams.
- You should be able to view the diagrams in SQL Management Studio just like a SQL Database.
- You should be able to view the diagrams when…4 votes -
HANA DirectQuery for Azure Analysis Services
It's available for PBI, would be nice to have it on Azure Analysis Services as well so we can build and manage our models in a single place. Doesn't make sense to pull data from one in-memory solution to another.
4 votes -
Enable Analysis service to access same region VNET Integrated services
Analysis service can not pull data from azure storage account if the VNET Integration is enabled on the storage account in the same region.
Enable VNET Integration like App Service VNET Integration preview feature as one example.
4 votes -
Improve Whitelisting
Currently users have to have their IP address whitelisted in order to promote or manage the model from Visual Studio. This can be difficult with remote employees as IP addresses can change and it is difficult to manually input a large amount. Ideally it would be nice if a new way could be created that is easier to manage large number of remote users. Maybe a security token of some sort?
4 votes -
Column and measure security
To me, the BIGGEST drawback of SSAS-TAB/AAS is the lack of security around columns and measures. In many cases, we need to give access to certain users to only part of the model. I.e: some users can see only sales, while others can see net margins (including costs).
Today, the only way to do this is to duplicate the model and drop columns or measure, which adds overhead in time and cost.
Maybe, if users could be locked to a perspective (and prevented from using freeform DAX), this could be accomplished ? Or something like that.
4 votes -
Straight Numeric Presentations
The demo on NYC Taxi Fares and Pickups was very nice, Mechanics. The graphical visualizations are totally sick! Still, I crave the golden days when the Pivot Table was truly multidimensional, just like in some of the earlier BIDS Browsers and Excel Services. Now its seems everything is flattened out - too bad. The Tabular Model and Power BI are cool, but it seems to me that "true" multi-dimensional grids with nicely aligned "dynamic stacking boundary lines" and cascading hierarchies provided a more interesting navigation and allowed drag-drop operations with instant dollar figures coming down the pipe to the display.…
4 votes -
4 votes
-
Support for non-native applications
Support for non-native applications. ie. Support for Java app using Analysis Service PaaS. REST or JDBC support
4 votesThanks for the update. I’m assuming you are talking specifically about URL access in such a way that works for 3rd party libraries such as OLAP4J and also general URL access without limitations around auth and resolving cluster IP addresses, etc.. We will look into it …
-
Ability to make a database hidden
I would like to be able to set a specific database as Hidden like I'm able to set a table as hidden.
The idea is to hide the development databases from the user-base.
This is an idea, which is targeted more to the on-premise Analysis services, but it can be useful for Azure Analysis services as well.
3 votes -
Allow Security Group to be added as Analysis Admin
Currently this supports only Distribution group but as a workaround the security group can be added through the SSMS tool using the objectId. We should be able to do this from the Azure Portal as well.
3 votes -
CubeDimension.HierarchyUniqueNameStyle
We have following scenario:
In Multidimension:
Dimension 1: ReceivedDate
Hiearchy: FiscalYearWeek
Year, Week
Dimension 2: DisDate
Hiearchy: FiscalYearWeek
Year, Week
When we pull the hierarchy in Rows in Excel or Power BI we see the name as
ReceivedDate - FiscalYearWeek
DisDate - FiscalYearWeek
This was due to property - CubeDimension.HierarchyUniqueNameStyleIn Tabular:
Table 1: ReceivedDate
Hiearchy: FiscalYearWeek
Year, Week
Table 2: DisDate
Hiearchy: FiscalYearWeek
Year, WeekWhen we pull the hierarchy in Rows in Excel or Power BI we see the name as
FiscalYearWeek
FiscalYearWeekIt creates probem for users that they do not understand the hierarchy that is is…
3 votes -
I was able to test the backup and restore for this service, Is there a way we can schedule this backup for Azure Analysis services?
We would like to Schedule this backup , Is there a way to do that ?
3 votes
- Don't see your idea?