Forms Data Controls :: Present An OLAP Cube From BI Development Studio In .aspx?
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
Similar Messages:
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
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
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
Jun 18, 2010
my requirement is : am having a excel sheet with some values listed i want to pass each value present in any(specified) column to a text box present on a remote page (a site other than mine) as a input and capture the result displayed on the page and then store the input and reuslt side by side in db this should repeat till the end of the input values in the excel sheet.
View 2 Replies
Feb 10, 2010
I am able to access the controls of ".aspx" file in ".aspx.cs" directly without any declaration in ".aspx.cs" or in designer.cs. How is this possible? This is happeing only if I open website as using File System.
Create a new ASP.NET web site application with Visual Studio 2008. So following three files will be created automatically
[code]...
How btnSave is being recognized by .cs file without defining it anywhere as an object of System.Web.UI.WebControls.Button?
View 3 Replies
Mar 12, 2010
I am trying to use SSIS Designer with BI Development Studio. I downloaded MS Visual Studio 2010 Beta and do not find an option to get into either the SSIS Designer or BI Development studio.
View 1 Replies
Jan 20, 2011
I'm trying to execute an aspx page but get this error.
Server Error in '/' Application.
The given key was not present in the dictionary. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
[Code]....
View 4 Replies
Apr 19, 2010
I have a webform that has a master page. In the web form I have a dropDownList it has PostBack=True, cause every time I changed the option I concat paratemer (item choosen) at hyperlink's navigate url property, for example I have 2 items:
id text
1 Option1
2 Option2
If the users select Option1 then concat at the url "?option=1" The problem is, that when I choose one option and then click at hyperlink everything goes right, but at the second time I choose an option the browser try to download de page itself aspx. update: even if I click at other hyperlink or link button after choose an option and click the hyperlink, the same thing happens (the browser ask me for download the page aspx)
I have no idea how to avoid this behavior at browser and it happens just at server with the IIS not while I'm testing at VS2008, update: ah I almost forget, if I click "cancel" at the prompt of firefox, then everything goes right again, until the next time I choose other option and click at the hyperlink, then everything goes wrong again...
Update (Code):
[Code]....
And here is the ASPX page
[Code]....
View 10 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
Jan 4, 2010
A year ago I did some design work for an ASP.NET 3.5 website that uses an SQL Server database hosted by my ISP. This website is only really active around this time of year for an annual photographic competition. Last year, I installed SQL Server 2008 Development Edition together with a trial copy of VS2008 Professional and the trial period lasted long enough for me to do what was needed back then. My intention was to buy VS2008 Pro around now in time for our current competition. In the meantime, I have reverted to
using VWD 2008 Express.
However, that purchase decision has been put on hold while I check out the economic and practical impact of waiting until VS2010 becomes available (in late March?). I'm guessing that it would be much cheaper to wait for VS2010 rather than buy VS2008 and then upgrade. Money is short because we are a non-profit organisation.
The practical issue is that I need access to SSIS Designer to update a DTSX file I created last year and I need that now. March is too late. The SSIS Designer is part of Business Intelligence Development Studio (BIDS) but BIDS is no longer available to me because it appears to have been provided with the trial copy of VS2008 rather than with SQL Server 2008 Development Edition. When I try to run BIDS I am told the evaluation period has ended. Is there is any way for me to gain free access to BIDS 2008 while I wait to buy VS2010?
View 8 Replies
Feb 27, 2010
I have a gridview which is present inside a repeater. I have been successful in displaying the data inside the grid view. Now I want to fetch data from the gridview. But i have not been able to fetch the data from the grid view.
View 5 Replies
Jun 15, 2010
with the code to present data in a gridview but without binding it to a database.
View 3 Replies
Mar 8, 2010
I have an application where I display the data from sql table to details view. There are many columns in SQL table, among them I combine two colums firstname and lastname to Name using templateField.
My code:
[Code]....
So, the problem is: If Name colum is empty, No data at all, I want to hide that Name column in detailsView.
View 7 Replies
Dec 5, 2010
here, i want to read the data for sql table, but there has error occur. "Invalid attempt to read when no data is present."
protected void DropDownListSelectDateYYYY_SelectedIndexChanged(object sender, EventArgs e)
{
Session["selectDate"] = Session["month"].ToString() + '/' + Session["day"].ToString() + '/' + DropDownListSelectDateYYYY.SelectedValue.ToString();
System.Diagnostics.Debug.Print(Session["selectDate"].ToString());
}
string sqlstr = "select * from ATTENDANCE where staff_Name = '" + LabelEmpSelected.Text.Trim() + "'and attendance_Date = '" + Session["selectDate"] + "' ";
whic session["selectDate"] cann't match to the database column data which is mm/dd/yyyy
View 3 Replies
Jun 15, 2010
I am handling the row databound event. I need to bind a dropdownlist which is present only in the EditItemTemplate.
So it is throwing:
DropDownList ddlAccountingPeriod = e.Row.FindControl("ddlAccountingPeriod") as DropDownList;
UIControlHelper.BindApprovalPeriod(ddlAccountingPeriod);
this throws a null exception as the dropdown is not present in the ItemTemplate.
Is there a way to check whether it is itemtemplate or edititemtemplate.
View 3 Replies
Nov 23, 2010
I have a 4 formviews present on a page. Three are updating to the DB without issue when the update link button is clicked. One is not. I have the DataKeyName set and still it doesn't save.
[Code]....
View 1 Replies
Feb 24, 2010
I have a <%Bind("prict")%> and I want to put the word Pri: in front of it but, it even appears if this field is null. How do I do this?
View 1 Replies
Nov 24, 2010
I've build a Class Library, in the same project i put a web project. But its impossible to access the classes from the dll generated by the class library. Whats wrong? JumpTide XML uses the namespace like:
namespace JumpTideClassLib
{
public class jumptidexml
{
public class MetaTags
{
Image:
View 1 Replies
Jun 1, 2010
I am having trouble trying to access a UserControl I created and placed inside the EditTemplate of the ListView. How is it done? I've tried to access it at the ListView's ItemDataBound, ItemEditing and Databound with the following code with no luck:
ucEditTask = DirectCast(lvTimeEntry.FindControl("ucEditTask"), UserControl)
View 2 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
Mar 28, 2010
I have a grid view and I added edit and Save buttons to it. When I click on edit I am able to edit the data but when I click on save I amgetting the data before edit.
Please see my code below.
Eg: I have start date as 2005-10-10 12:00 AM so After I click On edit it is letting me to edit, So If I edit the start date to 2010-10-10 12:00 PM and click on the save button I am stil getting the old start date. which is 2005-10-10 12:00 AM instead of 2010-10-10 12:00 PM
<asp:GridView ID="gvPosHistory" runat="server" AutoGenerateColumns="False" AllowPaging="True"
AllowSorting="true" Width="650px" PageSize="20" CssClass="Gridview" Visible="false"
OnRowCommand="gvPosHistory_RowCommand"
OnRowDataBound="gvPosHistory_RowDataBound"
OnRowEditing="gvPosHistory_RowEditing"
OnRowUpdating="gvPosHistory_RowUpdating"
onrowcancelingedit="gvPosHistory_RowCancelingEdit" >
<Columns>
<asp:TemplateField HeaderText="Start Date" SortExpression="startDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblstartdate" runat="server" text='<%# Eval("StartDate")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtStartDate" runat="server" Text='<%# Bind("StartDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="End Date" SortExpression="endDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblenddate" runat="server" text='<%# Eval("EndDate")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtEndDate" runat="server" Text='<%# Bind("EndDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Functional Job Title" SortExpression="JobTitle">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblFunctjobTitle" runat="server" text='<%# Eval("FunctionalJobTitle")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtFuncJobTitle" runat="server" text='<%# Bind("FunctionalJobTitle")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Department" SortExpression="Department">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblDepartment" runat="server" text='<%# Eval("DeptName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtDeptName" runat="server" Text='<%# Bind("DeptName")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Supervisor" SortExpression="Supervisor">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblSupervisor" runat="server" text='<%# Eval("Supervisor")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtSupervisor" runat="server" Text='<%# Bind("Supervisor")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Bargaining Unit" SortExpression="bargainingunit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblbargainingunit" runat="server" text='<%# Eval("BargainingUnit")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtBargainingUnit" runat="server" text='<%# Bind("BargainingUnit")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="UCP Level" SortExpression="UCPlevel">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblUCPlevel" runat="server" text='<%# Eval("UCPLevel")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtUcpLevel" runat="server" Text='<%#Bind("UCPLevel")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" SortExpression="Edit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<ItemTemplate>
<asp:LinkButton ID="LBPosHistoryEdit" Text="Edit" runat="server" CommandName="Edit" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Save" SortExpression="Save">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<EditItemTemplate>
<asp:LinkButton ID="LBPosHistorySave" Text="Save" runat="server" CommandName="SavePosHistory" CommandArgument='<%# Eval("UCPLevel")%>' ></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
.aspx.cs
protected void gvPosHistory_RowCommand(object source, GridViewCommandEventArgs e)
{
if (e.CommandName == "SavePosHistory")
{
string arg = Convert.ToString(e.CommandArgument);
System.Web.UI.WebControls.LinkButton btnPosHistory = e.CommandSource as System.Web.UI.WebControls.LinkButton;
GridViewRow row = btnPosHistory.NamingContainer as GridViewRow;
TextBox tSdate = row.FindControl("txtStartDate") as TextBox;
TextBox tEdate = row.FindControl("txtEndDate") as TextBox;
TextBox tFuncJobTitle = row.FindControl("txtFuncJobTitle") as TextBox;
TextBox tDeptName = row.FindControl("txtDeptName") as TextBox;
TextBox tSupervisor = row.FindControl("txtSupervisor") as TextBox;
TextBox tBargainingUnit = row.FindControl("txtBargainingUnit") as TextBox;
TextBox tUCPLevel = row.FindControl("txtUcpLevel") as TextBox;
}
}
View 1 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