what are the correct tools to create a cube from SQL server 2012?
I am new to this field. I am trying to create a cube from SQL Server 2012. I generally know how to create a cube using Visual Studio 2010. But I can not find Visual Studio 2010 to download (or to buy). The IT person can provider Visual Studio 2015, but I do not know which version do I need (Visual Studio Community, Visual Studio Professional, or Visual Studio Enterprise?).
I downloaded the free version of SQL Server 2012 from https://www.microsoft.com/en-us/download/details.aspx?id=50003 But we did not install all of the features (see image 1 below)
When I create a new project in SQL management studio, it looks like image 2.
Can anyone point me to the right direction?
Thank you very much!
Download this version of SQL Server Data Tools (SSDT) to get the templates to create a cube, https://www.microsoft.com/en-us/download/details.aspx?id=36843.
It installs a Visual Studio shell if you don't have Visual Studio installed already. It's enough to use the cube project templates. SSDT is all you need to start develop cubes, tabular models, Integration Services packages, and Reporting Services solutions.
- SSRS Query execution failed for dataset
- Insert leading spaces, then the value to a varchar(10) column
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?
- Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
- No PK or FK when exporting SQL Server database
- SQL Server SELECT LAST N Rows
- Order by Specific id first then By rest
- Fuzzy phrase similarity in SQL Server
- Union two selects removing duplicates base on some columns (not the full row)
- SQL fill gaps with hold
- Create login and logout rows from single row
- Create Index without name while creating table
- Extracting SQL Server table data to parquet file
- SQL, How to convert VARCHAR to bigint?
- PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
- SQL Server query to find all permissions/access for all users in a database
- How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
- How can I update top 100 records in SQL server?
- inserting data into SQL DB from C# ASP.NET
- Display the average number of days between a customer's last and second to the last transaction
- Fastest way to determine if record exists
- Unrecognized column name that I define
- What are the advantages of running SQL Server in a Docker container?
- How do I get the MAX of two values in SQL Server?
- How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
- Why can't I use table names of aliased tables in WHERE clause?
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- How to run sql script using SQL Server Management Studio?