sql-serverssascubessas-tabular
How to Find SSAS .sln files from tarbular cude that have been deployed to sql server to SSAS in visual studio
I have access to tabular cube that have been deployed to SQL Server Analysis Services (in SQL SERVER), But the parckage is that was deployed from is missing(That is the SSAS) and I am trying to find a way to open the cude in SSAS and add additional information to the cude eg columns and tables. See screen shot bellow (Just an example)
Is it possible to export this deployed cube back to SSAS so that I can see the underlying tables and relationship between the tables? Thanks
Solution
Yes, it is possible.
- In a modern SSDT-BI, start a new project
- Navigate to Business Intelligence->Analysis Services
- Click on "Import from Server (Tabular)
- Adjust a tabular model
- Deploy it back to the sever
- (highly recommended) Add a solution to a source control
- Why would you want to put an index on a view?
- Search multiple occurrences of a word in a string in SQL Server
- Trigger to fire only if a condition is met in SQL Server
- How do I perform a simple string mapping as part of a t-sql select?
- Maintainable INSTEAD OF trigger with Identity columns
- Using SQL Server 2008 Geography types with nHibernate's CreateSQLQuery
- Reset AutoIncrement in SQL Server after Delete
- How to create BAK file from azure sql db
- Microsoft Access SQL query
- Calculate the previous sundays date from a Date column?
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Exclude a row based on the status
- Condense Time Periods with SQL
- Joining Two CTE's with Pivots
- SQL Server query to find all permissions/access for all users in a database
- SQL Server convert decimal to EBCDIC
- Can't drag stored procedure onto dbml designer
- Return Stored Proc Results in CTE
- Optimizing Stored Procedure Query
- SQL PERFORMANCE - alternative to OR statement
- How to create index to optimize a "Key Lookup"
- Only members of the sysadmin fixed server role can perform this operation. Azure SQL Server Database vs SQL Server Database
- How to use min() together with other column in SQL
- Check for changes to a SQL Server database?
- SQL - Continue running all SQL statements even after error
- opposite of "top" in sql server, without using order by, there are no keys/indices
- Getting log messages from an SSIS package executed with an SQL query
- Project fails to load due to missing SqlServer.targets file after upgrading to Visual Studio 2013
- How to remove a specific character from a string, only when it is the first or last character in the string.
- convert datetime to bigint