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 RepliesTo use: System.Data.Oledb or ADOMD.NET .NET provides connection pooling by default. Can it acheived in ADOMD.NET?
View 4 Replieshow 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 want to connect one webpage to another using a command button called email. When the user clicks on the email button it should take them to another webpage where the user can select the emails they want to send to. Then they will click the OK button and it will return them to the previous webpage where they can type in their email and write a message and hit submit.
View 1 Repliesi want to write aspx page html from aspx.cs page on page load..
i hav already used div.innerHtml...
i want to write below code in aspx page from aspx.cs page
[code]....
how to write code in asp.net c# on how to process a cube?
View 1 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 Repliesis it possible to place an aspx page inside the update panel of another aspx page? if possible let me know the way to do that.
View 1 RepliesHow can I call a public property declared on a ASPX page from a different ASPX Page? Is that possible? It is a website project. How can I get/call this property from a different aspx page? I have attempted this from the other page, but it is not recognizing the partial class: private Test_Default _test; It does not recognize the "Test_Default"
I.E.
[code]....
what i wanna do is:
there is an dropDownList in the master page with 4~5 items.
i've prepared 4~5 sub-page related to the above item. when the dropDownList.ItemChanged, the subpage content will show their own page.
use html iframe to include another aspx page.
in my cs code:
[Code]....
but when i change the item in the dropdownlist, the error pops up:
[URL]
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 RepliesI 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]....
How we can open a new aspx page in update panel embedded on current page. I want to open that page on some ajax event...
View 7 RepliesWe 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 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 RepliesThis program used to work when I had VWD 2005 express and SQLSERVER 2005 express. Then we upgraded to VWD 2008 express and SQLSERVER 2008 express. Now it fails Error running adodb Provider cannot be found. It may not be properly installed. 3706 To clarify; I used to run variations of the following to create small offline cub files that I could email to remote Users:-
PROVIDER=MSOLAP;
DATASOURCE=C:TESTAMRunAdodbTestMyCube.CUB;
SOURCE_DSN=AMCubeData;
CREATECUBE=CREATE CUBE AMCubeData(
DIMENSION [Channels],
LEVEL [ALL Channels] TYPE ALL,
LEVEL [Channel Group Name],
LEVEL [Channelname],
MEASURE [Sales Val]
Function Sum
Format 'Standard');
INSERTINTO=INSERT INTO AMCubeData(
[Channels].[Channel Group Name],
[Channels].[Channelname],
MEASURES.[Sales Val])
SELECT [ChannelGroupName] AS Col1,
[channelname] AS Col2,
[Sales Val] AS Col23
FROM dbo_qryCubeDataExtra
;
in a VB6 program that ran them in a ADODB connection something like :-
Dim MyCnn As ADODB.Connection
On Error GoTo Err_ErrorHappened
Set MyCnn = New ADODB.Connection
MyCnn.Open (MyAdodbcmd)
I have an aspx application with 2 aspx pages. Second aspx page will get opened on click of a button in first aspx page using JavaScript. The problem is, when the second aspx page is getting opened, its Page_load event is not firing. Only when I refresh the second page, page_load event of second aspx page is fired. what might be the problem and what is to be done to fire the page_load event.
View 1 RepliesI wrote a test page that does a bunch of busy work in a method called at page load. This process as I have it now takes around 12 seconds.
If I try to load another page while the first long running page is loading, this second page doing nothing except writing out a world, it doesn't load until the first long running page is finished.
Why is this the case? I would think IIS would be able to handle multiple concurrent connections, it seems crazy that one long running page would stop every other page in the application from loading. I must be missing something or not understand how IIS works.
I would think multiple independent requests would be spawned on different threads. Is this only the case if the requests are from different sessions entirely? Are all requests from a single session bound to a single thread?
I have page A.aspx where I show some result in listview. When I click On Some data on listview I go to page B.aspx. Now the problem is when I click on back in page B.aspx it comes to A.aspx with out previous listview result. Ack requirement is when I come to page A.aspx result of listview has to be there. How do i do that?
View 2 RepliesI work in VS 2008. Whenver I add a server control(Label) and set it properties in aspx.vb and build the solution, I get the error "Label1 not declared". While analyzing this issue I noticed that the event handler statements for the Label1 where not added in the designer.asp.vb file. These statement would actually be added automatically when I drag and drop a control to my webpage.
I would also like to inform the scenario after which this problem came to me. I was working in VS 2008 , VS 2005 and VS 2003 in the same machine.Could this have caused the issue ?
Now each and everytime when I add a control, I am adding the "With Events" code in the designer page to make my build succesfull which makes me to spend more efforts.
I wants to run an application on other API page to retrieve data from that page by selecting different options to my .aspx page. consider as example [URL] If i use this API page to retrieve data to my .aspx page every time from " Intraday Chart " web part i can have separate display on my page. I can change Nifty / Sensex tab option also in there.I have tried with WebClient method parsing..
View 2 Repliesi have my first aspx page that has data thatthe user fills in. it is in format of textbox's and at the end of it all the user clicks submit and all data goes in the database. In the database each record gets an ID field. Now when the users clicks submit and goes to the next page, i want the ID's (they could be 1 to 1000+) from the DB that he just inserted and have them available on the second page. how can i take all the id's from page 1 to page 2? can i do it in session? or something else. Please put some sample code so i can understand better.
View 2 RepliesI have code something like this.
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Submit", "Confirm()", true);
Confirm is the JavaScript function in .aspx page. I want to catch the "true" or "False" value returned based on the Click performed on the Confirm window to my code behind(aspx.cs) page.
i have to give the user the option to upload his own aspx and aspx.cs files on to the server, adjust the hyperlink to point to a page which would do the following display the aspx and aspx.cs files code onto the page without actually rendering the code the browser should not understand anything, and while reading the files to display them the method be such that nothing is processed on the server regarding the code within the files to prevent from unnecessary problems many user would try to cause.
i have tried many ways of displaying it but it ends up on displaying the actual comments instead of the code. how to achieve the above. note main concentration is on asp.net and c# using vs08, so j script and ready-made tools be avoided if feasible
have a page called: TagUpdateReportPalletDeadSurplus1.aspx. On this page I have a link to a second page calledptPalletSurplusAndDeadDirectFromURL.aspx with a ms reportviewer report.I pass a parameter called ConfirmationID to the second page with a query string.Here is an example of the query string:http://localhost:4132/StateTag/rptPalletSurplusAndDeadDirectFromURL.aspx&rs:Command=Render&ConfirmationID=2010-02-08-12:27:37Do I have the correct syntax in the query string?How do I get the second page (rptPalletSurplusAndDeadDirectFromURL.aspx) to accept the parameter and pass it to the rdl report?
View 4 Replies