To do so, just click on the “New Page” button Now we want to add a new page to the report.To do so you just need to drag and drop “SalesAmount” from FactInternetSales and “CalendarYear” from DimDate just like what we did befor. Now we want to create a new diagram to show yearly sales amount.When you hover over a country you can see the sales amount for that specific country.Click on the “Change visualisation type” and click on the map to see the SalesAmount by SalesTerritor圜ountry on the map.
As you can see SalesAmount automatically moved to Value section and SalesTerritor圜ountry moved to Axis section. Now you have a diagram showing SalesAmount by SalesTerritor圜ountry. Now drag and drop “SalesTerritor圜ountry” from the “DimSalesTerritory” on the middle of the created diagram. You’ll have the “SalesAmount” diagram in the middle of the report. Drag “SalesAmount” from fields list and drop it in the middle of the designer. Simply tick all needed tables then click load. Whatever you can see in the following database diagram should be selected from the navigator list: In this sample we want to create some reports for “Internet sales”, so we select all related objects. If you can’t, make sure you have access to browse the database and select the objects. 
Now you should see a list of tables and views in the navigator. Key in the server name and database name and click OK. To configure the AdventureWorks OLAP cube. ADVENTURE WORKS DW 2012 DOWNLOAD DOWNLOAD
Use the following procedure to download and deploy the cube. So, click on “SQL Server Database” from the list. Once you have configured the login for the Analysis Services service account, the next step is to download and deploy the AdventureWorks OLAP cube. In our sample we need to connect to SQL Server.
As you can see there are lots of other data sources available to connect to. To connect to SQL Server click on “Get Data” or “New Source”. If you want to get more familiar with the tool click on the videos on the startup screen. Open the Microsoft Power BI Designer Preview. I’ll use AdventureWorksDW2012 as the source database. First of all you need to download the designer from here. It’s so fun to use the tool to create very effective and flashy reports in a short amount of time. At the first look, I would like to say it’s an amazing tool integrating lots of awesome features all together with ease of use. So I added an idea into BI in SQL vNext as I believe it would be great to have PowerPivot functionalities included in the release version of the product. At the moment PowerPivot models are not available in the designer, but, hopefully Microsoft will add it to the tool. Some features like PowerPivot models expected to be available to the release version. Saying that the tool is still a preview version and it’s NOT actually a released product we’ll expect to see more features when it’s released. Microsoft Power BI Designer is basically an integration of Power Query and Power View. I will use Adventure Works DW database as the source database. Then we’ll see how easy we can create a report using designer. Now, you can see the “AdventureWorks2012” database in SSMS.First of all I would like to briefly explain Microsoft Power BI Designer. So, you need to select the file name (AdventureWorks2012_log.ldf) having file type “log” and message “Not Found” and press the Remove button.Īfter that press OK to finish the installation. After that click on Add button and browse the file (AdventureWorks2012_Data).Īfter that, if you press OK button, it will reflect error as given below. Right click on the databases and click on Attach. The physical file name “C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Log.ldf” may be incorrect.ĬREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file ‘C:\AdventureWorks2012_log.ldf’.Ĭould not open new database ‘AdventureWorks2012’. On (FILENAME= N'C:\AdventureWorks2012_Data.mdf')įile activation failure. On (FILENAME= N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf')įor testing purpose lets put it in the root directory : So, we need to write the script given below to create the database and in order to build a new log file, we need to use ATTACH_REBUILD_LOG. Once you download the file, you will notice that it has only data file and not log file. You should copy the data file to any appropriate location but it should not be in the root directory due to the security issue. Adventureworks2012 case sensitive date fileĪfter downloading the appropriate data files lets proceed with the installation :. Adventureworks sample database launched with SQL Server 2012 and you can download it from the codeplex.
0 kommentar(er)
