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 RepliesWe are trying to design selection tool for a hierarchical dimension (e.g. org-dept-subdept) in order to query SSAS cube. When user clicks a drop down list, a tree view will pop out for user to select single or multi tree nodes. Ideally it would be like the drop down box used in Excel pivot table when it is connecting to a SSAS cube. If there is any Ajax control that can perform similar function
View 1 RepliesI 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 RepliesHow to query a SQL database with Dropdown Value Selected as All. Supportgrp is a Dropdown List, if i select All in the Dropdown List all
values from the database should be displayed.
I use the below code currently without All selection:
[code]....
In subsonic 2 we could do this:
public static void DeleteTable(SubSonic.TableSchema.Table table)
{
new Delete().From(table).Execute();
}
How can we do the same thing in v3? I can only seem to find documentation about using generics to target a specific table in the database...I want to be able to use it with a parameter as above.
I would like to alter the query that is run, depending on the selection made by the user in a drop down list on the same page. Would this best be done using a partial page update (AJAX)? Ideally it would be great to have the textbox result change quickly once the drop-down list value has changed, without a full page postback. I would like to change the SQL query to a completely different query if the user selects an option different to the default (page_load value) in the drop-down list. I would then like the newly retrieved result to be displayed in the textbox as before.
My current VB function looks like this:
[Code]....
I load a flv movie into my project, so I can set its dimension manually but how can I get the dimension of flv movie by programming?
View 2 RepliesI have scanned the web, and see things but nothing clear to me.
View 4 RepliesI have an ASP.NET page with a listbox whose selection mode is set to multiple by default. I would like to set its selection mode to single on a button click.
Code snippet of my attempt:
$('#testBtn').click(function(){
$('#testListBox').attr("SelectionMode","Single");
});
It is not working though. What am I doing wrong here and how to get it to work?
Trying to Add a Dropdownlist Selection to a Query String. When I use this :
[Code]....
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]....
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 RepliesI 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?
How can I add another dimension as string to this:
list<patientInfo> strlist
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 Repliesi have a two dimensions array:
[Code]....
but it require to specify the second dimension; im missing something...
i try to wrote the following on my view:-
<%: Html.TextAreaFor(model => Model.article1.Article_Body, new { value = "FL", disabled = "disabled" }, new { cols = "50%", rows = "20%" })
to disable the textArea and also specify its size, but the above statment raised an error mentioning the i can not specify three parameters?
I was wondering if anyone can help me work out what the user has selected in this selection changed event?his is what I have so far:
protected void rblNavigation_SelectedIndexChanged(object sender, EventArgs e)
{
string url = (GetCurrentPageName()).ToString() + "?" + Request.ServerVariables["QUERY_STRING"];
[code]...
The problem is that rblNavigation.SelectedValue is not the value that the user has selected to trigger this event. How do I get the value the user has just selected?I'm using C# and this selection event is inside my MasterPage.
how to write code in asp.net c# on how to process a cube?
View 1 RepliesWould 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 RepliesI know I can use arrayName.length to find out how many items in total in the array there are, but how can I gracefully find out how many items are in a specific dimension? I know I could probably do it in a for each loop, but it would look a little messy, does anyone know of a simple way that I may have overlooked?
View 3 RepliesI 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 RepliesWe 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 RepliesTo use: System.Data.Oledb or ADOMD.NET .NET provides connection pooling by default. Can it acheived in ADOMD.NET?
View 4 Repliesi added a collection of data into a list box. i have another group of data with a group name.i want to add this group in to that same list box as a tree structure.
the sample list box is shown below.
item1
item2
item3
-group name
group item1
gruop item 2
gruop item 3
item 4
item 5
is there any way to do this. when clicking on the group name it must be expanded within the list box and i want to manage all these elements with an index.