Best Option To Retrieve Analysis Services (SSAS) Cube Data Dynamically In MVC
Mar 18, 2011
I need to dynamically add/remove dimensions and facts in web application and get results from SSAS. The cube in SSAS is defined and ready to use. So far the best idea I found is use MDX queries to get metadata from SSAS cube and display those data in web page. Then user can choose needed dimensions/facts and I need to costruct dynamic MDX query and get results from SSAS. Communication with SSAS is made with AdomdDataReader. Is there better options to solve this task that require less effor? Maybe somehow make use of Reporting Services (SSRS).
View 1 Replies
Similar Messages:
Mar 24, 2011
We are trying to design a selection tool for hierarchical dimension (e.g. org-dept-subdept) in order to query SSAS cube. When user clicks a dropdownlist, a tree view will pop out for user to select single or multi tree nodes. Ideally it would be like the dropdown box used in Excel pivot table when it is connecting to a SSAS cube.
View 1 Replies
Mar 15, 2010
As per this MSDN article:
W3C Extended Log File Format (IIS 6.0)
It says cs(Referrer) contains the REFERER information that can be read from the IIS log files.
I am trying to display the log information using an ASP.NET Repeater control:
<asp:Repeater ID="rptlIISLogEntries" runat="server">
[Code]....
View 1 Replies
Jan 11, 2010
How to retrieve data from database using Web services on VB?
View 5 Replies
Jun 16, 2010
I want to apply regression analysis on my financial data.Can anybody have the sample code for this.And which method i should prefer for financial.
View 1 Replies
Feb 4, 2010
I had created a cube in SSAS. After creation my data in Fact table is updated. Now my cube still shows old data. How to refresh data in a cube automatically
View 1 Replies
Dec 4, 2013
I want one column Category having values Travelling,Food,Air Fare,Auto Rental in gridview.Now I want date and day as header for next columns and I can insert record datewise in grid. I want it as following image.
View 1 Replies
Mar 18, 2010
I am able to dynamily bind my grid to the cube based off the facillity I have selected. Now, if a facility has multiple cubes, I want the users to switch between the two cubes dynamicly, so I have created a drop down list showing their cubes and the ones that they can select. Currently I'm been trying several things in order to "rebind" the data but they don't seem to be working, so I figured I would attach my code to see if anyone Had a good idea.
If I make the cube change then switch back over to change facility and then back to the page, the new cube will load. So I have to find a way to do it in the one step rather then have them navigate to another page and then back again. Perhaps auto navigate them to a page and have that page send them back etc... Anyway here is the code: I first bind the data via the page_prerender call
[Code]....
Then the code drops down into the LoadCube(FacilityID) sub routine
[Code]....
Then here is the setup for the subroutine that will call the page load/ should change the cube to the correct cube.
[Code]....
View 1 Replies
Mar 29, 2010
I have 2 different lists: EmployeeNames and Names. I read the values in Names and that of EmployeeNames.
If EmployeeNames exists in Names, I must not add that value to "ToSelectBox" but to "FromSelectBox".
If EmployeeNames doesn`t exist in Names, I must add that value to "ToSelectBox" but not to "FromSelectBox".
How can I do that dynamically?
I have 2 option values as follows:
<select id="fromSelectBox" multiple="multiple" >
<% foreach (var item in Model.EmployeeNames) { %>
<option value="<%=Html.Encode(Item.Text)%>"><%=Html.Encode(item.Text)%></option>
<%}
%>
</select>
select id="ToSelectBox" multiple="multiple" >
<% foreach (var item in Model.Names) { %>
<option value="<%=Html.Encode(Item.Text)%>"><%=Html.Encode(item.Text)%></option>
<%}
%>
</select>
View 1 Replies
Dec 9, 2010
how to present a .cube created in BI Development Studio as part of a .aspx page? Windows Server 2008 hosting the site using IIS 7. The SQL server and the management studio and the BI Development Studio used to create the .cube are on the same windows server. Am using Visual Studio 2010 Premium to develop for .NET Framework Verison 4. Using an impersonation account to control access to the db.
View 1 Replies
May 26, 2010
I have this gridview made.But it gets populated with columns, column names and template fields dynamically. The template field tht I am using throught the field in each colum is a textbox. The user when loads this page sees a gridview with texboxes in all the columns. I need to be able to retrieve the data entered by the user in the textboxes on a button click.
public class GridViewTemplate : ITemplate
{
private DataControlRowType templateType;
private string columnName;
public GridViewTemplate(DataControlRowType type, string colName)
{
templateType = type;
columnName = colName;
public void InstantiateIn(System.Web.UI.Control container)
{
switch (templateType)
[code]...
View 8 Replies
Oct 16, 2012
How to retrieve selected value of dropdownlist in gridview when dropdown is added dynamically from database.
View 1 Replies
Mar 24, 2011
I have a dropdownlist("ddlTemplate") control and a gridview("gvPlanning") control with 1 BoundField column, 1 TemplateField column and remaining columns will be generated dynamically from database.In TemplateFiled Column i have 3 image buttons viz: Edit, update and cancel.Gridview will be populated based on the selecteditem of dropdownlist.
if i click on edit imagebutton, i need to add textboxes dynamically in all the columns of that row except first 2 column. And if i click on Update imagebutton i need to retrieve the textbox values.we can add template field column for textboxes also, but why i am sticking to this method is.. the number of columns changes depending on the selecteditem from the dropdownlist. Eg: If i select india from dropdownlist the number of columns in the gridview would be 4 and if i select UK from dropdownlist the number of columns would be 9 likewise.
View 5 Replies
Sep 7, 2010
I have a modalpopup extender that is brought up if the user presses a button. This is fine and the user can enter the data. There are a number of textboxes and dropdownlists. However, I have a gridview which I want to bring up modalpopupextender so the user can edit an entery. How can I set the data to the controls? A dynamicpopulate extender will repopulate the modalpopupextender with all the data. It doesn't make sense for me. Is there anyway I can populate the data with c#? Also can I assign two buttons to call the modalpopupextender?
View 2 Replies
Mar 19, 2010
I am new to using ADOMD for accessing SSAS cubes. I am having an issue with concurrency. I am using ADOMD to connect to SSAS 2005 in an ASP.Net 2008 application. When a user executes an MDX query and the ASP.net page opens an ADOMD connection, a second user that tries to execute an MDX query gets "a connection is already open" error. I don't understand how ADOMD works. Does it open only one connection for all users because ASP.Net is using a single account for all connections from the web server? I do not have this problem when using ADO.net in the same manner.
View 2 Replies
Mar 31, 2010
I am working with Visual Studio Team System 2008. Now I would like to create SSAS project using the same.
But the SQL Server 2005 is not installed in my system. Its available only in the Database Server.
let me know, whether the SQL Server 2005 should be installed in the developer (my) system for creating SSAS and SSRS projects?
View 1 Replies
Apr 4, 2011
I am using code analysis tool of VS 2010..two things that i have noticed was not provided:
Proper casing of variable,method and properties names xml comments for each method,event and other activities
View 4 Replies
May 14, 2010
I am aware of a tool which MS has provided which tells you about coss site scripting attack etc.
The tool is [
But are there tools which you have used for ASP .NET applications which do similar to this and which one is widely used in ASP .Net applications ?
View 2 Replies
Feb 8, 2010
how to write code in asp.net c# on how to process a cube?
View 1 Replies
Dec 10, 2010
Would like to present a .cube built in SSAS in an aspx page. Using Visual Studio 2010 for development. SQL Server and MS Analysis Server are running on remote 2008 server. I'm new to aspx and .net, can someone get me started?
View 1 Replies
Jun 29, 2010
I have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
[Code]....
View 4 Replies
Jul 28, 2010
I'm coding an ASP.NET page, with VB code behind. When the user clicks a button on the page, I send them an email with information and instructions. Rather than sending a plain text email, I send a nice, pretty, HTML-formatted one. Right now, I'm doing this in a way that I KNOW will be difficult to maintain. That is, I'm straight up writing out all of the html. i.e.
markup += "<fieldset>"
markup += "<legend>"
markup += "Required Documents"
markup += "</legend>"
and so on. Is there a way to create an aspx page (with vb code behind), and send the html of that page in the body of the email? The information is dynamic, so this pseudo-page would need logic in the on-load event to format the html correctly.
View 4 Replies
Sep 13, 2010
I am building a webform dynamically but when I go to get the values the placeholder has no controls. Every control added has an unique ID. Does anyone know what I am doing wrong (language is C#).
aspx page
<asp:UpdatePanel ID="upShoppingCart" runat="server" UpdateMode="Conditional" >
<ContentTemplate>
<asp:PlaceHolder ID="phShoppingCart" runat="server" />
<br /><asp:Button ID="btnUpdateCart" runat="server" Text="Update" OnClick="btnUpdateCart_OnClick" />
[Code]....
View 6 Replies
May 4, 2010
In our project we need to restore the analysis service database back up(.abf) files.Now i can connect to analysis service and can create new database.May i know how i can restore the abf file .i saw i can do this by using sql server SMO dll .check the below link
[URl]
how to get the samples are located in <system_drive>:Program FilesMicrosoft SQL Server100Samples folder,if you alrady installed the documentation
View 1 Replies
Mar 18, 2010
We have a SQL agent job tied to an SSIS package that process does an Update process on the dimensions and a full process on the Facts. In the morning the cube is showing that it is processed but the new data is not present. When it is manually run the SSIS package, it seems to work fine. Basically there is job having two steps, one is to update the BI Cube and next step is to update dimensions and facts. This jobs runs perfectly without any error, but first step executes as per the expectation and second fails to update with latest data. If we try to manually run the SSIS Package of the second step it perfectly updates with the latest data.
View 2 Replies
