microsoftdocs / bi-shared-docs Goto Github PK

The docs say there are only two storage options for dimensions: ROLAP and MOLAP. However, in VS 2019 a third option exists: InMemory.

What does this option do?

https://github.com/MicrosoftDocs/bi-shared-docs/blob/master/docs/analysis-services/tabular-models/calculation-groups.md#sideways-recursion

DAX example must either provide argument 3 for the DIVIDE function, or omit it.

The TMSL sample has object attribute instead of target attribute. The example fails. SSMS generates the script with target instead and it works.

The links for MSOLAP libs are showing 404 not found.
https://download.microsoft.com/download/3/8/B/38B8BD8C-E6AB-4B9F-AB1E-03C59A477C48/1033/x86_15.0.2000.802_SQL_AS_OLEDB.msi

https://docs.microsoft.com/en-us/analysis-services/tabular-models/add-a-table-ssas-tabular

says hit the Existing Connections button from the Model menu in SSDT.

But that's not there anymore; to add tables from existing connections you right click on the data source in the Model Explorer and hit "Add New Tables"

Currently there is no documentation on Feature \ ParallelSourceQueries

https://github.com/MicrosoftDocs/bi-shared-docs/blob/main/docs/analysis-services/server-properties/feature-properties.md

Hi,

Is there way to excute dmv queries using JDBC driver?

I can see documentation to run SQL using Microsoft JDBC Driver. However, I do not see any documentation for analysis service

Dear Author - when talking about MDX limitations in the context of a Tabular model, could you make it clear that you are talking about MDX queries executed against the tabular database from outside. Or if these are some kind of MDX expressions in the tabular data structure (which I thought was not possible) what are they? Thank you!

Hello.
It seems that in Defining and browsing KPI page associated measure group option select is missing.

I expect that the tutorial will say what option I should select. Like in first example.

Tried this code (based on here):

using (Server server = new()) {
      server.Connect(connectionString);

      string newDatabaseName = "Tabular - [New Database]";

      Database blankDatabase = new() {
          Name = newDatabaseName,
          ID = newDatabaseName,
          CompatibilityLevel = 1500, //1130 and higher
          StorageEngineUsed = StorageEngineUsed.TabularMetadata,
          ModelType = ModelType.Tabular //Databases can have a ModelType of default. Default is equivalent to multidimensional, and thus does not support the use of reserved characters in column names.
      };

      server.Databases.Add(blankDatabase);
      blankDatabase.Update(UpdateOptions.ExpandFull);
  }

getting the error that reserved characters are not allowed:

fail: Function.HandleProcessStreamCreateModelAsync[3] Executed 'ProcessStreamCreateModelJobHandler.HandleProcessStreamCreateModelAsync' (Failed, Id=b6f4580e-ea83-4b38-96e3-bc1514b6a3bf, Duration=27000ms) Microsoft.Azure.WebJobs.Host.FunctionInvocationException: Exception while executing function: ProcessStreamCreateModelJobHandler.HandleProcessStreamCreateModelAsync ---> System.InvalidOperationException: The 'Name' property cannot contain any of the following characters: . , ; ' ` : / \ * | ? " & % $ ! + = ( ) [ ] { } < > at Microsoft.AnalysisServices.NamedComponentCollection.ValidateForAddOrInsert(NamedComponent obj) at Microsoft.AnalysisServices.NamedComponentCollection.Add(ModelComponent item) at [...]

fail: Host.Results[0] Microsoft.Azure.WebJobs.Host.FunctionInvocationException: Exception while executing function: ProcessStreamCreateModelJobHandler.HandleProcessStreamCreateModelAsync ---> System.InvalidOperationException: The 'Name' property cannot contain any of the following characters: . , ; ' ` : / \ * | ? " & % $ ! + = ( ) [ ] { } < > at Microsoft.AnalysisServices.NamedComponentCollection.ValidateForAddOrInsert(NamedComponent obj) at Microsoft.AnalysisServices.NamedComponentCollection.Add(ModelComponent item) at [...]

Attempting to perform an online attach (https://docs.microsoft.com/en-us/analysis-services/what-s-new-in-sql-server-analysis-services?view=asallproducts-allversions#sql-server-2019-analysis-services) in SSAS 2019.

the attach command

provides an error:

Executing the query ...
Attach with AllowOverwrite=true over existing database is supported only for databases with DBStorageLocation property specified. The database 'EnterpriseModel' that is being attached has no DBStorageLocation specified.
Run complete

if we attempt to run the attach command w/ DBStorageLocation specified:

we receive the error message:

Executing the query ...
The DBStorageLocation element at line 12, column 20 (namespace http://schemas.microsoft.com/analysisservices/2003/engine) cannot appear under Envelope/Body/Execute/Command/Attach.
Run complete

We also attempted to

1. backup/restore on the processing server to set the dbstoragelocation
2. detach the solution w/ dbstoragelocation set
3. copy the solution over to the query server
4. attach as the query server solution
5. run the online attach and received the same error

Location: In Connection Strings, "User ID=...; Password=" (link below), on the 4th bullet "If you've already acquired a valid AAD bearer access".

Limitation: For the PowerBI XMLA endpoint, when using an OAuth token for a password, it only works from a published service, and returns 401 Unauthorized when running locally.

Note: This may need to be validated by the Analysis Services team.

Connection Strings: UserID and Password

Links are Wrong. Correct links are mentioned below for Article: https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/backup-and-restore-of-analysis-services-databases

First Change:
How to Backup an Analysis Services Database (TechMantra) Link has changed from https://www.mytechmantra.com/LearnSQLServer/Backup_an_Analysis_Services_Database.html to https://www.mytechmantra.com/sql-server-analysis-services/how-to-backup-analysis-services-database-in-sql-server-using-sql-server-management-studio/

Second Change: Step by Step Article is on MyTechMantra.com and not on TechMantra

Third Change: Link has changed for Automate Backup of an Analysis Services Database from https://www.mytechmantra.com/LearnSQLServer/Automate_Backup_of_Analysis_Services_Database.html to https://www.mytechmantra.com/sql-server-analysis-services/how-to-automate-backup-of-analysis-services-database-using-sql-server-agent-job/

In https://github.com/MicrosoftDocs/bi-shared-docs/blob/6b4fba5ce278b1fdc801cee554e7673009cba21d/docs/analysis-services/tutorial-tabular-1400/as-adventure-works-tutorial.md it is not explained that the Standard tier of Azure Analysis Services should be used because lesson 10 creates multiple partitions.
If people create a resource with the Basic tier they will need to delete and reprovision their Analysis Services resource.

In tabular tutorial, the partitioning doesn't match the data in the AdventureWorksDW2019 database. As a result, no rows are returned when I process the partitions. (Unless, of course, I've missed something and am doing something wrong!)

bi-shared-docs/docs/analysis-services/tutorial-tabular-1400/as-lesson-10-create-partitions.md

I am using the AdventureWorksDW2019 database found here

It wouldn't surprise me if the data was updated after this was published.

The default value of n as in n-order Markov chain is missing in the document.

Also, where can I find reference on how to change the value of n?

Thanks in advance!