Click here to Skip to main content
Click here to Skip to main content

Building ASP.NET Reporting OLAP-Based Application Part-2

, 21 Apr 2009 CPOL
Rate this:
Please Sign up or sign in to vote.
How to build Reporting ASP.NET Web application
In the previous post we learned how to build simple cube using BIDS, and if you’re follower I’ve forgot something important is deployment the cube on the Analysis Services. 1- We just need to add some attributes to the dimensions(DimPromotion, DimProduct) as each of which pure (contains just the key) for some reasons we need to show the user the name of product, or the promotion because it very hard to make human treat with numbers contrary to machines which prefer them. We shall add some attributes to the dimensions to make it meaningful. 2- Double click on DimPromotion; the dimension design window opened you find Data Source View, Hierarchies and Attributes; simply drag EnglishPromotionName from the Data Source View table to Attributes. 3- Repeat the previous step with the DimProduct to add EnglishProductName

rs-p2-7

4- Right click on AdventureWorksInternetSalesCube project then deploy (to move your cube to the Analysis Services). If deployment succeeded it shows you message Deployment Completed Successfully

rs-p2-2

rs-p2-3

Now it’s the time to build our Report. 1- Right click on the solution, then Add->New Project-> Select Business Intelligence Projects from Project types then create Report Server Project Wizard, with name “InternetSalesReport” 2- OK

rs-p2-41

3- Report Wizard dialog open, Next; Select New data Source; Type: Microsoft SQL Server Analysis Services then Edit; Server Name: your server name in my case I’ll type “RamyMahrous-Lap” you will notice that when selecting the Data Source as Microsoft SQL Server Analysis Services there is no any chance to login using Username or password as we illustrated in the previous part Analysis Services permits just Windows Authentication. Select or enter database name: “AdventureWorksInternetSalesCube”; Test Connection and then OK if succeeded.

rs-p2-5

4- Next; we come to the dialog to build the query; press on the Query Builder to open a Query Designer form to help us building the Report Dataset. We need to show ProductEnglishName, PromotionEnglishName, and FactInternetSaleCount and the parameters are ProductEnglishName, and PromotionEnglishName so we’ll drag the ProductEnglishName, PromotionEnglishName, and FactInternetSaleCount on the space which shows “Drag levels or measures here to add to the query”. And ProductEnglishName, and PromotionEnglishName on dimension area and check parameter checkbox. OK

rs-p2-6

rs-p2-8

rs-p2-9

5- Next; select report type as Tabular; next; add available fields to details; next;next; rename it to InternetSaleCount_ByProduct_ByPromotion; finish. 6- You can preview it and select some criteria to test the report. 7- Right click on InternetSalesReport and Deploy to deploy it on the Reporting Service Server to enable users to access it over http. If you got message The specified TargetServerURL is not valid. Specify a valid URL for a report server in the deployment settings. Right click on InternetSalesReport project then properties set the TargetServerURL to http://localhost/ReportServer or your ReportServer URL, check it from IIS. Conclusion: We’ve showed building Report using BIDS and deploying it on ReportServer. Stay tuned the last part building the ASP.NET application.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Ramy Mahrous
Software Developer LINK Development
Egypt Egypt
Business Intelligence Developer at LINK Development which is a wholly subsidiary of LINKdotNET, graduated from Faculty of Computers and Information | Helwan University, Cairo, Egypt | 2003 - 2007, Computer Science as a Major, he has a passion for community, latest knowledge delivering and Q&A forums.

Comments and Discussions

 
GeneralExcellent Article PinmemberMadhu Kampurath9-Sep-09 23:06 
GeneralRe: Excellent Article PinmemberRamy Mahrous10-Sep-09 0:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.141015.1 | Last Updated 21 Apr 2009
Article Copyright 2009 by Ramy Mahrous
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid