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

In the previous two posts building the Cube and building the Report, we discovered how BIDS helps in developing BI applications in robust, managed and organized way. I believe if you have few BI concepts you can do this walkthrough in 10 minutes.
Let’s come to the last layer which I see it’s the presentation layer. One question may come to your mind why I build ASP.NET application over Reporting Service? Why I don’t give the end user Reporting Service Server URL. Because of security? NO. Reporting Service Server can manage different types of security which doesn’t put headache on your development team but what if your end user need UI layer say in Silverlight? How can you embed in the Reporting Service. We have ReportViewer Windows\Web control which provides a very rich of functionality to View Reporting Service (Local and Server) Reports. In our walkthrough we use Server Report.
Let’s open our previous solution and add a new ASP.NET web application project: InternetSalesWebsite
Default.aspx page open in source view, switch to Design view.

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

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

How to create SQL Server Login programmatically?

Q. How to create SQL Server Login programmatically?

I got this question from Daniweb C# forum, and of course when I need to do something against SQL Server object from .net I go to SMO (SQL Server Management Objects) which provides a great functionalities to do anything with SQL Server instead of going on SSMS and create some scripts then embedding them into stored procedure then call it…. off…

Anyway to avoid showing how much I’m talkative…

Create any C# project type (Windows, Class Library or even Console one), add reference to Microsoft.SqlServer.Smo, Microsoft.SqlServer.ConnectionInfo
and Microsoft.SqlServer.SqlEnum
Server sqlServerInstance =
new Server(new Microsoft.SqlServer.Management.Common.ServerConnection(
new System.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=Master;Integrated Security=True")));
// your connection string I place mine for illustration..
Login loginObj = new Login(sqlServerInstance, @"DomainName\UserName");
loginObj.DefaultDatabase = "Master";
loginObj.LoginType = LoginType.WindowsUser;
loginObj.Enable();
loginObj.Create("password");
//set the password
//there're many properties to do some tasks related to Login object...
If you used LoginType.WindowsUser, be sure to provide valid windows username and if you aren’t on Domain use the machine name instead.

If you need to create SQL login use LoginType.SqlLogin…

You can explore Login class more on http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.login.create.aspx

 

 

 

Requirements Engineering – FCIH Microsoft Club

	Microsoft-Club Helwan Requirements Engineering session JOIN US FOR THIS EXCITING EVENT Let’s start, to share our knowledge and find ways to make a difference. Let’s Start with our First Session with, “Requirements Engineering session” (E.g. RE is the branch of software engineering concerned with the real-world goals for functions of, and constraints on software systems). Come and join us this event @ FCI-H. Agenda: · Who Am I; a programmer or developer or…? · What and Why of Analysis..!!! · The “Others” needs · Requirements Management · Requirements Elicitation · Requirements Analysis · Requirements Communication Speaker’s Bios: Marwan Hamad is currently System Analyst in Link Development. In 2004, He started the journey of analysis in ITWorx while he had the honor of working in the enterprise sales field at Microsoft Egypt. Marwan observed the best practice of Business Process Reengineering (BPR) by providing dynamic workflow based on strategic objectives to Vodafone Egypt and New Horizons. Marwan was honored from the Ministry of Youth in 2004 for transferring European Project Management practices to the Egyptian NGO’s. Marwan studied Applied Business Computing in the University of Sunderland, UK. DON’T MISS OUT 2:00 pm – 4:00 pm Wednesday, December 17, 2008 FCIH main campus, Hall 7 (beside the mosque, 2nd floor) Faculty of Computers & Information – Helwan University Hope to see you there! Microsoft Club – Helwan Referral Code: Club08 Contact us: msp-helwan@student-partners.com P. S. RE session mainly for all students, everyone is welcomed. P. S. If you know anyone else who’d enjoy this event, please forward this email to them now.

New .NET Logos announced.

Microsoft announced last friday the new .Net logos.

Source :-
http://blogs.msdn.com/chkoenig/archive/2008/10/24/new-net-logos-announced-today.aspx

Microsoft Announces Visual Studio 2010. Developers Respond.

Source:- http://www.cio.com/article/print/451622 

.NET Framework 3.5 Service Pack 1 has been released

ASP.NET in the .NET Framework 3.5 Service Pack 1 release includes numerous bug fixes. In addition, it includes features for the following:

• Enabling high-productivity data scenarios by using ASP.NET Dynamic Data.
• Supporting the browser navigation in ASP.NET AJAX applications by using ASP.NET AJAX browser history.
• Increasing the download speed for ASP.NET applications by using ASP.NET AJAX script combining.

More about .NET Framework 3.5 Service Pack 1, Press Here

Microsoft Infrastructure IT Professional Sessions – August 19

Yet another event invitation from Kareem Salah(IT Professional Audience Marketing Manager Microsoft Egypt)

You are courteously invited to attend our August IT Pro Session on Windows Server 2008. This session is a very special one where we will be having an IT Professional, Waleed Omar, discussing his actual implementation of Windows Server 2008 with a focus on Terminal Services. Waleed from Mantrac is one of the very first IT Professionals in Egypt to deploy the new Terminal Services in Windows Server 2008 in his production environment, which is currently used to provide remote application access to users across multiple countries.
Microsoft has published a case study on the implementation of Windows Server 2008 Terminal Services at Mantrac by Waleed, which you can view at:
http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000002026
Waleed will be providing a technical overview of the new features of Terminal Services in Windows Server 2008, along with hands-on-lab and a discussion of the implementation at Mantrac.
Microsoft is delighted to invite you to attend our August session, entitled Windows Server 2008: Implementation at Mantrac. Attendance is free-of-charge but Seats are limited.

C# 4.0 is not a dream, it is comming :)

I Have Nothing to say, just Check this Link

—— Welcome C# 4.0 ——

Differences between some references in Enterprise Library 2.0 and 3.1

While working with Microsoft Enterprise Library 3.1 I’ve found there is difference in some references. I was working with DAAB (Data Access Application Block), in Microsoft Enterprise Library 2.0 we was refer to Microsoft.Practices.EnterpriseLibrary.Data.dll in 3.1 and 4.0 you should browse it manually \bin\Microsoft.Practices.EnterpriseLibrary.Data.dll and for some reasons you need to add reference to Microsoft.Practices.EnterpriseLibrary.Common.dll