Forms Data Controls :: Rebinding OLAP DataGrid To Another Cube
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
Similar Messages:
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
Oct 4, 2010
I am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is thrown
View 5 Replies
Mar 15, 2010
I have a GridView and Formview attached to the same ObjectDataSource.
Everything is working ok so far.
If I enter new search criteria and click "Search", both the GridView and FormView rebind properly to the ObjectDataSource results. And I am able to page through the FormView records and they match the GridView records above.
When I click a sort link in the GridView, the ObjectDataSource returns the correct results based on the header link's commandName of 'Sort' and the CommandArg of 'SortExpression'.
The only thing wrong now is on the sort, the formview records do not reflect the reversing of the sorted record order. If I page through the FormView the records remain in the same order.
Why does the FormView not recognize the ObjectDataSource's changed results on the sort post back (even if it is only the sortExpression parameter of my ODS select method).
How do I get the FormView to rebind to the new ODS result set? I have called formview.DataBind() from every event I can think of. That does not seem to work either.
View 6 Replies
Jan 30, 2011
I have a text box in a FormView that I use to display the return value from the stored procedure that I'm using to maintain the data. For assorted reasons, I'm not able to use the built in ability of the FormView to manipulate the data.
I have the following code at the end of the procedure that calls the stored procedure. It is a snippet that omits the bulk of the procedure.
[Code]....
As is, the label text is updated with the message. However, when I uncomment out the code that manipulates the SQL Data Source and rebinds the FormView, the label text is NOT updated. I can't figure out why it craps out.
1) AdvisoryMessageText is declared at the class level for the code behind, so it should be retaining the value across all of the procedures as their caloled.
2) TextBoxAdvisoryMessage is contained within the FormView EditTemplate.
View 1 Replies
Aug 26, 2010
I am working with a formview edititemtemplate. Currently in my page load, i have some stuff that would show or hide certain panels based on dropdownlist values. These dropdown values get binded during page load. I need to be able to change the values/dropdowns, without rebinding the old data, and updating the visibility of the panels based on predefined rules.
I have experimented with putting my formview.databind() in page load if isnotpostback, in prerender, in prerender if isnotpostback. I have tried my rules (ex if ddlState.selectedvalue = "DE" then pnlDelaware.visible = "true") in the page load, and the page render. I'm just not sure how to get the stars aligned here. The closest i have come is having the databind in the pageload if notispostback, and the rules in the prerender. However I get an error "dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items.
View 4 Replies
Jun 16, 2010
I m using two radio buttons, The binding of the data to chart switches according to the radio button selection, but it shows only the data that is selected for the first radio button
View 4 Replies
Apr 6, 2010
I have 2 grids gvParent & gvChild I would like to filter gvChild when a row is selected in gvParent the linking fields are contractNo
I added a column for selecting:
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
OnClick="LinkButton1_Click" Text="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
I know how to handle the filtering of the grid (create a criteria and set to rowfilter of the dataview) But, I dont know how to get the value of the column of the selected row.
View 5 Replies
Mar 4, 2011
I have Datagrid , i want to clcik on row and get data in textbox , but my textbox is FreeTextBox control,i tried to use javascript but work for asp.net control not working for freetext box control, how i can capture this code is sample code but it work for asp.net control but not working for my freetextbox
[Code]....
View 1 Replies
Sep 22, 2010
Simply put... I want to duplicate the example found at this link, in VB.net rather than C#.
[URL]
I would like the selectedvalue of the dropdown to display additional data base on its selection in multiple text boxes.
I have tried using the DropDownList OnSelectedIndexChanged property, within a DataGrid EditiItemTemplate, but I cannot retrieve data from the selection. (AutoPostBack is "True"). I can however use a button onclick event to fire a "prre-defined" selection value.
View 2 Replies
May 27, 2010
I have 2 datagrid (using .net 1.1). I need to access column of second grid ( i need to make a column of second grid as disabled) when i click "Cancel" link button in First Grid. How can this be done?
View 7 Replies
Apr 14, 2010
The chart on my project is populated click of a button using Chart1.DataSource = The data the chart displays depends on the selection made from a series of drop down lists before the button is clicked. I need to be able to create the chart, then be able to change the selections of the drop down lists and click the button again to show the new data but I am getting the error "A chart element with the name 'element name' already exists in the 'SeriesCollection'" Do I need to "unbind" the data/series before re-binding and resetting the properties of the chart each time the button is pressed?
View 10 Replies
Sep 30, 2010
I have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
View 1 Replies
Feb 8, 2010
how to write code in asp.net c# on how to process a cube?
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
Feb 25, 2011
[Code]....
I created a GridView that uses a custom paging method that allows for alphabetical paging. I seem to be having some problems now rebinding the GridView after a delete occurs. The row is deleted, it's just that the rebinding doesn't happen so to the user it looks like the delete failed. Been over and over my code and can't understand why. See the final block which is supposed to fire on the GridView1_ItemDeleted event.
View 4 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
Mar 10, 2010
To use: System.Data.Oledb or ADOMD.NET .NET provides connection pooling by default. Can it acheived in ADOMD.NET?
View 4 Replies
Jan 8, 2010
I had called the data from query to data table and now i have a gridview in which i am using one datalist and 2 text boxes and and reming coloumns are bounded iahve to assiaign them values which datatable have either null or any value.
View 2 Replies
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
Jun 13, 2010
it will be very interesting that controls for input in forms have another property ie semanticid semanticname so semantically can be relationate i.e textboxes content if then we retrieve the data using linq having olap cubes we could have a lot of diferent views comunicating diferent controls of diferent webparts that shares the same semantically set or point to same ontology for the several dates or same localization from different input forms collection data,etc.
View 3 Replies
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
Oct 4, 2010
I am fairly new to the asp.net scene. Having build a dashboard gathering info on my OLAP system's health status, I can't seem to figure out how to make sure that I catch the no connection exception.I use the following statements on the datagrid:a) want to change the color of ssas2 button to red if an exception is throw
MyDBConn.ConnectionString =
"Provider=MSOLAP.4;Data Source=core-ssas2;Integrated Security=SSPI;Initial Catalog=Financials;Connect Timeout=6000"
MyDBConn.Open()
MyDBConn.CreateCommand.CommandTimeout = 120
View 1 Replies
Oct 27, 2010
I have a live working website (ASP.NET 3.5) that pulls data from an OLAP cube on a remote server without any problems. However I now need to move the website to a different web server, and for reasons unknown I cannot get the OLAP queries to work in the new location.
I have installed the same versions of .NET Framework (3.5) and ADOMD.NET (8.0) on both servers, and the website pages were copied across servers with no changes made, so this can't be a coding issue. However I get errors like the following when the new site tries to query the OLAP cube:
[Code]....
(Note: run_olap_query is my method that attempts to run the query). The error would there is a mistake in the syntax of the MDX query, however that is definitively not the case. I have retrieved the MDX that the page attempted to run at the error reporting stage and have run it manually in Analysis Services - it returns results with no complaints. The same MDX queries are also still running quite happily on the original website.The only notable difference I can spot between the servers is that the original server has SQL Server 2000 installed and the new server has no version of SQL Server, but I would not expect the site to need SQL Server on the local machine to run these queries. Does anyone know if this is the case? I'm somewhat stumped as to what the cause of the issue is here, and am completely out of ideas as to where to look.
P.S. Here is my code, though I do not think it will be relevant:
[Code]....
View 4 Replies
Oct 10, 2010
I have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....
View 3 Replies
