FCI-Helwan blog

Just another FCI-H weblog

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.


Continue reading


July 2, 2009 Posted by | Business Intelligence, Microsoft, MSSQL, SQL Server | 1 Comment

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

Continue reading

July 2, 2009 Posted by | Business Intelligence, Microsoft, MSSQL, SQL Server | Leave a comment

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;
//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




April 28, 2009 Posted by | .NET Q and A, C#, Microsoft, SMO, SQL Server | 3 Comments

Requirements Engineering – FCIH Microsoft Club

Microsoft-Club Helwan
Requirements Engineering session


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. 🙂

· 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.

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.


December 17, 2008 Posted by | Announcements, Concepts, Microsoft | 1 Comment

New .NET Logos announced.

Microsoft announced last friday the new .Net logos.

Source :-

October 27, 2008 Posted by | Microsoft | 1 Comment

Microsoft Announces Visual Studio 2010. Developers Respond.

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

September 30, 2008 Posted by | Microsoft, VSTS | 1 Comment

.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

August 24, 2008 Posted by | ASP.NET, Microsoft | Leave a comment

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:
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.

August 4, 2008 Posted by | Announcements, Microsoft | Leave a comment

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

I Have Nothing to say, just Check this Link

—— Welcome C# 4.0 ——

July 21, 2008 Posted by | C#, Microsoft | 1 Comment

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

July 17, 2008 Posted by | Microsoft | Leave a comment