Microsoft BI (Build up PowerView Reports) SQL Server 2012 PowerPivot for SharePoint 2010 works in iPad 2, iPhone 4S, Windows 8 Tablets, Windows Phone 7.5 & SmartPhones

The latest interactive BI tool of SQL Server 2012 is PowerView Reports which runs as an integrated Reporting Services app of SharePoint 2010. The PowerView Reports provides interactive support for Bubble Charts, Line Graphs along with the Matrix, Cards support having Metro Style UI approach.

Lets build an app to consume Windows Azure Data Market feed API on Excel PowerPivot . So, open Excel PowerPivot & select Azure DataMarket Feed API.

• Lets Sign up for the Data Feed from Azure MarketPlace & get the dataset Atom feed URL. You need to provide the Account Key.

• Lets populate the Azure DataMarket Feed data on Excel PowerPivot & develop the PivotCharts to analyse the World Health Statistical Analytics.

• Now, save the Excel sheet & send it to SharePoint PowerPivot Gallery where we can start to build the PowerView Reports.

• Lets run the PowerView report build on SharePoint 2010 on iPhone 4S device & check the PowerView reports run on iPhone , iPad , Windows 8 tablets, Windows Phone , Android & all smartphones.

Building RhoMobile MVC application with HTML 5 , JQuery for iPhone,iPad, Windows Phone, Android,BlackBerry

RhoMobile is an alternative native application environment for smartphones other than PhoneGap. To build applications with RhoMobile , you need to download RhStudio from http://rhomobile.com/products/rhostudio/ & choose your appropriate version for Windows or Mac.

• Next to create smartphone applications with Rhomobile, you need to install Rhodes , RhoSync, RhoConnect , Gits. The four Rhomobile products – Rhodes, Rhosync, RhoHub, and Rhogallery – provide a complete toolkit for creating a mobile application. Rhomobile is cross-platform and so allows you to build your application for many different types of smartphone – including iPhone and Blackberry – just with a single codebase. This makes it the most preferred and quickest way of developing mobile apps. As you create a native Rhomobile application, you can use the built-in device features such as GPS, Push, and Camera, all with offline capabilities.

• Select File-> New Project-> Rhodes Application-> Select your Project name.

•  Set out the Rhodes Model of the application by right clicking on the project of the Project Explorer & Select Rhodes Model. Provide Name & Controllers.

• Next , you will find three types files inside the app folder of your project & after setting the Models , a seperate folder named as your Model name will be created.
• The files created as default are basically of  three types :
• product.erb -> This is the Model file, which contains the Model Definition.
• product_controller.rb -> This file contains the business logic relates to our Model.
• *.erb-> The .erb files are the html view template files.

• Lets the controller view of Rhodes Views for smartphones:

• Lets  edit the Views as ‘Index.erb’ in HTML 5 for Rhodes application for smartdevices.

<div data-role=“page” data-url=“<%=Rho::RhoConfig.start_path%>/”>

  <div data-role=“header” data-position=“inline”>

    <h1>Storemanager</h1>

    <%if SyncEngine::logged_in > 0 %>

    <a href=“<%=url_for:controller=>:Settings,:action=>:do_sync%>”class=“ui-btn-left” data-icon=“refresh”>

      Sync

    </a>

    <a href=“<%=url_for:controller=>:Settings,:action=>:logout%>”class=“ui-btn-right” data-icon=“star”>

    Logout

  </a>

    <%else %>

        <a href=“<%=url_for:controller=>:Settings,:action=>:login%>”class=“ui-btn-right” data-icon=“star”>Login</a>

    <%end%>

</div>

  <div data-role=“content”>

    <ul data-role=“listview”>

      <li><a href=“Product”>

      <span class=“title”>Products </span>

      </a></li>

    </ul>

  </div>

</div>

• Run the Project by right clicking project -> Run Configuration -> Right Click on RhodesMobile-> Select New -> Select your simulator Environment.

• Select your RhoMobile Simulator as iPhone & check the application output native iPhone platform.

• Web – Inspector View for HTML 5 , JQuery Mobile Codes.

• Products Sample Entry Screen with MVC HTML 5 , JQuery Mobile in iPhone.

• Check the Project View in Android Platform:

• Product Samples Screen in Android:

• Windows Mobile View for RhoMobile :

• 

Migration of an Existing On-Premise ASP.NET 4.0 Web Application to Windows Azure Part – I

In this world of Cloud, it’s very necessary to run your enterprise business apps in Cloud & provide the solution of better scalability, elasticity , High Availability & 24*7 on features to your customers.

• Windows Azure is Platform as a Service (PAAS) model which helps to upgrade us in such a service. In this article , an existing on-premise enterprise healthcare application has been migrated into cloud & hosted in Microsoft Data – Centers.
• To start working with Microsoft Windows Azure in Visual Studio 2010, Download the Windows Azure SDK from Azure website.  http://www.microsoft.com/windowsazure/sdk
•    Now , First load your existing enterprise asp.net 4.0 application into visual studio & then in the solution explorer of the project right click on the solution & click Add-> New Project.

• Now Select a new Windows Azure Project & named it & save it in the same folder of your existing on-premise application.

•  In the Roles folder of your Windows Azure Project , Right Click, select Add & choose Existing Web Role in Solution. 

• Now, check your existing asp.net web application has been migrated as a WebRole in Windows Azure Project.  Next , Set up your Windows Azure hosting environment. During compilation of your Windows Azure application in your development machine , you may encounter the following error:

     

• Resolution: To solve this error, Open Windows Azure SDK Command Prompt in elevated mode & run the following command.

C:\Program Files\Windows azure SDK\v1.3\bin\ DSINIT /SQLINSTANCE:YourSQLServerInstanceName /Forcecreate  

• If you dont have .SQLEXPRESS  as default instance of your SQL Server instance then you can modify the command as

C:\Program Files\Windows azure SDK\v1.3\bin\ DSINIT/sqlInstance:. 

•   Now , You will get the following prompt for initialization of  Azure Storage Emulator in development fabric.

• Next , Build your complete project solution & run the Windows Azure Project with existing ASP.NET 4.0 web application. During the debugging you will see the compute emulator  & storage emulator in your local dev fabric .

•  Check out your on-premise existing asp.net web application migrated to windows azure & running in azure compute emulator in local development fabric.

• To deploy the application , right click on Azure Project & Click Publish & create package (.cspkg ).

    

• Now, select the radio button of Create Service Package Only otherwise select the second option if you would like to configure your Windows Azure Hosted service details in Visual Studio.

• Build the Azure Service Package File (.cspkg) & Service Configuration (.cscfg) in Windows Explorer.

• Next , Log on Windows Azure Developer portal with Windows Live ID with valid Azure Subscription & continue deployment.

ASP.NET MVC Razor Template with JQuery Mobile Web for Android, Windows Phone , BlackBerry

ASP.NET MVC 3 Razor applications with JQuery Mobile is pretty straightforward for developing rich web for mobile. This article demonstrates to build asp.net mvc 3 Razor applications with JQuery , HTML 5 & CSS 3 templates running in smartphones . Build an application for ASP.NET MVC Razor application in Visual Studio 2010 & add the following JQuery template in _layout.cshtml:

<!DOCTYPEhtml>

<html>

<head>

<title>@ViewBag.Title</title>

<meta name=”apple-mobile-web-app-capable”content=”yes”/>

<meta name=”viewport”content=”width=device-width; initial-scale=1.0″/>

<link rel=”stylesheet”href=”@Url.Content(“http://code.jquery.com/mobile/1.0a4.1/jquery.mobile-1.0a4.1.min.css&#8221;)”/>

<scripttype=”text/javascript”src=”@Url.Content(“http://code.jquery.com/jquery-1.5.2.min.js&#8221;)”></script>

<scripttype=”text/javascript”src=”@Url.Content(“http://code.jquery.com/mobile/1.0a4.1/jquery.mobile-1.0a4.1.min.js&#8221;)”></script>

</head>

<body>

@RenderBody()

</body>

</html>

Next , Put the code in Index.cshtml for SmartPhone View:

@model IEnumerable<MVC3_JQueryMobile.Models.HMS_000ITEM>

@{

ViewBag.Title = “Index”;

Layout = “~/Views/Shared/_Layout.cshtml”;

}

<div data-role=”page”>

<div data-role=”header”>

<h1> Health Record </h1>

</div>

<div data-role=”content”> 

<ul data-role=”listview”>

<li>@Html.ActionLink(“Patients Record”, “Index”, “Home”)</li>

<li>@Html.ActionLink(“Daily Health Record”, “Index”, “Category”)</li>                   

<li>@Html.ActionLink(“View Report”, “Index”, “Expense”)</li>

</ul>

</div>

<div data-role=”footer”>     

<nav data-role=”navbar”>

<ul>

<li><ahref=”#”class=”ui-btn-active”>Patient Details</a></li>

<li><ahref=”#”>Report Chart</a></li>

<li><ahref=”#”>Contact Us</a></li>

</ul>

</nav>

</div>

Check out the output in Android & Windows Phone 7.1 & BlackBerry 9800:

•    Check in BlackBerry 9800 Browser :

• Testing Website in Internet Explorer 9 for Windows Phone 7.1 Mango :

ASP.NET MVC 4 with Windows Azure for Windows Phone 7, BlackBerry, Android & i-Os.

Though MVC 4 is still in developer preview , not released in RTM phase but there is cool staff of development of ASP.NET MVC 4 applications for desktop & Mobile with Windows Azure environment.

Since it’s always been a great experience with working of MVC with Windows Azure of rich web experiences in Cloud. So , Lets a Windows Azure application targeted for Mobile Smart devices (Windows Phone 7, BlackBerry 7 , i-Os, Android ) & deploy in Azure of Microsoft Data Centeres.

• Let’s Create a new Windows Azure Application from Visual Studio & do not add any webrole to it as we will add our ASP.NET MVC 4 webrole with it . (P.S:  Those  who have already MVC4 Webrole Template installed in Windows Azure environment of Visual Studio , can go & take a MVC 4 Web Role Template).
• For those who dont have MVC 4 WebRole Template for Windows Azure environment for Visual Studio can simply create the blank Azure Project as we will add ASP.NET MVC 4 web application project later.

•  Check out the  WebRole sections, Click OK as we dont need to take WebRole from default WebRole options.

•  Next , Check out the Blank Azure Project created in your Visual Studio solution with ServiceConfiguration.cscfg & ServiceDefinition.csdef files.

• Now , Time to add a new ASP.NET MVC 4 Project from Visual Studio , so on the solution explorer right click the solution -> add -> new project -> choose New ASP.NET MVC 4 Web Application.

• Next , Add the ASP.NET MVApplication C 4 application with Windows Azure Project . To do this , right click on Roles of your Windows Azure project & select Web Role Project in Solution . Redirect to Associate Web Role Project in Solution Window  & Click OK.

        Check the ASP.NET MVC 4 web application has been added as webrole in Windows Azure Roles.

• Click OK to add the existing MVC 4 solution with Windows Azure Application.
• 
•  Now it’s time to run the Windows Azure Project with ASP.NET MVC 4 in development fabric. So hit F5.

•  Now time to test the application in Mobile Devices so , test in Windows Phone as this asp.net MVC 4 web application project has been enabled for Mobile apps.

•  Associate Page View 

•  Now , Test it in Android 2.2 & Android 3 Tablet device.

•  Android 3.0 Tablet View for ASP.NET MVC 4 Windows Azure Application.

•  Run it on BlackBerry OS of BlackBerry 9800 device.

•  So the Windows Azure Application with ASP.NET MVC 4 for mobile is ready for development fabric , so deploy it Azure VM & run it from cloud to mobile.