Share via

Visual Studio and SSAS

Don75 81 Reputation points
2022-12-23T18:25:54.69+00:00

I have a question regarding Visual Studio and SSAS.
I created a "Analysis Services Tabular Project" in VSS. Connected to the SQL database and got the required tables and was able to publish to SSAS server. It created the required Database and tables on SSAS.
My question is, I am going to have multiple people creating "Analysis Services Tabular Project" in VSS. I want all of them to submit to the one database in SSAS without creating multiple ones.
I would like to know whether this is possible?
Any help is great appreciated.

SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,616 Reputation points
    2022-12-27T06:54:29.937+00:00

    That would be only possible, if all users works with the same one SSAS solution (project), otherwise the users overwrites the changes of other users.
    Use a version control software to manage the changes of each user into one solution.

    0 comments
  2. Anonymous
    2022-12-27T02:47:15.633+00:00

    Hi @Don75

    Due to my current device conditions, I'm sorry I can't help you test if this is possible.
    After I looked up a lot of cases, I didn't find any of them that succeeded in doing this. I'm afraid it won't happen.

    Best regards,
    Percy Tang

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.