.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

Suggestion for web based Ad hoc OLAP reporting tool

Posted By:      Posted Date: October 31, 2010    Points: 0   Category :Sql Server
 
Hi Guys,

I want a suggestion from you people regarding the best tool for OLAP reporting.

What I want to do is

Allow administrator to create OLAP based web report, which he/she can publish to users of his/her choice.
Similarly can create dashboards using the OLAP.

This needs to be done in web based application.

Can anybody suggest any 3rd party tool for this??

Thanks in advance
XLP_Clarion


View Complete Post


More Related Resource Links

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

  

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003


Debugging Tool: Build a Logging and Event Viewing Library to Help Debug Your .NET Framework-based Ap

  

Building a basic, reusable application framework can make development quicker and easier. This allows you to focus more on the problems at hand and less on the repetitive tasks involved in building any application. In this article, the author presents a framework that provides facilities to access the registry and an extensible framework for logging messages to a console window or the Event Viewer. This reusable framework can be included as a library in your projects, allowing you to display an enhanced, color-coded message log and dynamically change logging levels.

Daryn Kiely

MSDN Magazine May 2003


Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT

  

One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.

Roy Margolis

MSDN Magazine July 2002


OLAP and excel reporting

  
Hi guys:I have an OLAP database which I need to create a reporting facility for my users, Excel seems to be fine, I have a web site and need to place a link for users to donwload the reports.  The thing is that once the report is downloaded I cannot drill down or do any query operation because the report it is trying to connect to the remote server (of course once dowloaded it is outside of the network) It is there any sugestions on how to address this issue?, maybe storing the data in the excel sheet? what about using reporting services instead?Thanks in advance

Windows Identity Foundation (Claims Based Authentication) for Reporting Services

  

Hi

I see that SQL Server 2008 R2 Reporting Services now supports Claims Based Authentication in Sharepoint 2010, meaning that end users can authenticate with Sharepoint using Claims Based Authentication, and use the same security tokens to connect through to Reporting Services.

I assume that behind the scenes Sharepoint is using Windows Identity Foundation (WIF - formerly codenamed "Geneva") to handle the authentication, and passing this on to Reporting Services.

I'm keen to use Windows Identity Foundation to authenticate with Reporting Services without Sharepoint. We have an existing ASP.NET web application, and we'd like to call Reporting Services from that, passing on the Windows Identity Foundation credentials of the user logged into our web application.

I've done some work on setting up a custom security extension using Forms Authentication (based on the sample), but am not sure how to proceed from there.

Google/Bing hasn't been helpful. Can you please point me to some guidance on how to set up Windows Identity Foundation authentication for Reporting Services?<

Permissions Reporting Tool Not showing all features - SPS3.0

  

I just installed the Sharepoint Admin Tools ver 4.0 and went through the deployment and activation of the Permission Reporting Tool.  Everything appears to have installed correctly and the tool does show as deployed and activated.

The problem I am having is when I go to a sites settings, the only option from the Permission Reporting Tool that is listed under Users and Permissions is the "Check Effective Permissions".  "Broken Inheritance Report" and "Compare Permission Sets" options are not shown anywhere that I can find.

Any suggestions on what I can possibly to do or what is maybe going on?  I'm new to SharePoint and not quite sure which direction to go in.  The only thing I could think of is that maybe these options aren't available with SPS 3.0?\

Any help is appreciated, Thanks!


Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)

  

Hello,

In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

Excel
-----
An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name
-----
OK

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Best solution for reporting OLTP/OLAP?

  

Hi,

I am not sure if this is the correct place for this question. We have a reporting requirement. The OLTP database is SQL Server 2008R2. Number of reports required is 6 and not sure about the number of users to provide access. On an average 20k records are added per day.  Now as the number of reports is just 6, is it worth to create a multi dimensional database (OLAP)? Are there any OLTP reporting tools ? Any help would be appreciated.


Suggestion for accessing OLAP via ASP page.

  

Recently I have a project required to use ASP.net technology to access SQL2005 AS cubes

and interact like an olap browser (drag and drop, slice and drill).

I search for while and notice that many vendors provide Commercial products on such controls tool addon for VS

or Client side product for browsing like Radar Soft, and DevExpress.

But I need to build a in-house one, can I get some suggestions or hints to start?

 

Thank you!

Terence

 


Visual Case Tool - UML Tutorial

  
The Class Diagram

The class diagram is core to object-oriented design. It describes the types of objects in the system and the static relationships between them.

5 GridView Themes Based on Google's Personalized Homepage (igoogle)

  
One of the silly features I have found that I like about igoogle is how the pages color palette changes depending upon the time of day. So as the day progresses from morning to afternoon to evening the colors on the page change as well. Like I said, I know this is a silly feature, but I like it. And I have asked around a little bit and seems like other people like it to. To get a better idea of how the colors change, here are the background images from a few of the HTML elements.

WPF Geometry Transformation Tool

  
The geometry transformer is a simple tool I wrote to scale-, translate- and rotate-transform a geometry in the path mini language.

Integrate Reporting Services with Silverlight and RIA Services

  
One of the most wanted future features in Silverlight is the possibility to create business reports using Reporting Services. In this article, I will show how to use the existing Reporting Services technology with Silverlight and RIA Services combination.

dynamically adding sql server columns based on number of files in fileuploader

  

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

 

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

 

Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")

objConn.Open()

Unique content within master page based on conditions met

  

 Hi all-

I would like to present users with unique content based on certain conditions being met as they land on the home page (default.aspx).  The condition logic will be in the VB code behind Page Load event. The content will go in a content placeholder as specificed from the master page. 

However, the content change wouldn't be something small (ie making a panel or label visible or not) but rather it will be different HTML,  Divs and databound gridview content.  The HTML content will be stored in the database.

Can someone point me in the right direction for best practices on how to accomplish this?

Thanks!


Problem making Role based Menu in MVC application

  

Hi,

 I want to make Rolebase menu in MVC such that if user doesnot have permission for some action then that Action name shouldnot be shown in the Menu.

 I have used the code in the url(http://forums.asp.net/t/1566328.aspx) in my MVC application.My application is a Discussion Forum(in MVC) same functionality as in this forum forums.asp.net

 I have used Controllers for post, thread etc.In each controller there are some actions that are using [Authorize(Roles)] attribute

 but this coding does not count  those Actions in Controllers having Authorize attribute according to the url http://forums.asp.net/t/1566328.aspx 

 In the code, Authorize attribute is applied to Controller class, but my requirement is of Applying Authorize attribute to some actions in controller so that some are available for all users and  some links are available rolewise.Now what is the solution for that?

 

Regards

Run Button Behavior: Suggestion/Bug

  

Note: This could be a bug or considered as suggestion. I am not looking for solution.


1: I have ImageWatermark.cshtml open and currently in focus.

2: I have Photo1.jpg selected in left Files workspace.

3: Now if I Click "Run", instead of opening ImageWatermark.cshtml it trys to open Photo1.jpg and it fails.

So ideally I would expect the "open file (ImageWatermark.cshtml) to run rather than running the selection from Workspace.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend