How-to implement sleep in sql server 2005

use myDb
go
-- sleep for 10 seconds
WAITFOR DELAY '00:00:10' SELECT * FROM My_Table

How-to list all the users and roles in all databases in a SQL Server 2005 instance

/**
Script: list all Usernames, Roles for all the databases.
Author: Shiva Challa (http://challa.info)
and the database Roles that the user belongs to in all the databases.
Also, you can use this script to get the roles of one user in all the databases.

Directions of Use:
For All Users list: You can directly run this script in SQL Server Management studio
For a specific user:
        1. Find this code and u.name like ''tester''
        2. Uncomment the code
        3. Replace the Name ''tester'' with the username you want to search on.

Resultset:
        DBName: Database name that the user exists in.
        Name: user name.
        GroupName: Group/Database Role that the user is a part of.
        LoginName: Actual login name, if this is null, Name is used to connect.
        default_database_name
        default_schema_name    
        principal_id
        sid

Change History:
8/26/2008 Removed the misc characters from the "Select of EXEC sp_MSForEachdb" statement.

**/

USE MASTER
GO

BEGIN

IF EXISTS (SELECT TOP 1 *
FROM Tempdb.sys.objects (nolock)
WHERE name LIKE '#TUser%')
DROP TABLE #TUser

CREATE TABLE #tuser (
DBName VARCHAR(50),
[Name] SYSNAME,
GroupName SYSNAME NULL,
LoginName SYSNAME NULL,
default_database_name VARCHAR(50) NULL,
default_schema_name VARCHAR(256) NULL,
Principal_id INT,
sid VARBINARY(85))

INSERT INTO #TUser
EXEC sp_MSForEachdb
'
SELECT
''?'',
u.name,
CASE
WHEN (r.principal_id IS NULL) THEN ''public''
ELSE r.name
END GroupName,
l.name LoginName,
l.default_database_name,
u.default_schema_name,
u.principal_id,
u.sid
FROM ?.sys.database_principals u
LEFT JOIN (?.sys.database_role_members m
JOIN ?.sys.database_principals r
ON m.role_principal_id = r.principal_id)
ON m.member_principal_id = u.principal_id
LEFT JOIN ?.sys.server_principals l
ON u.sid = l.sid
WHERE u.TYPE <> ''R''
/*and u.name like ''tester''*/
order by u.name
'

SELECT *
FROM #TUser
ORDER BY DBName,
[name],
GroupName

DROP TABLE #TUser
END

how-to backup the current directory by adding a timestamp to it in windows

@ECHO OFF
ECHO BACKUP_CURRENT_DIR.CMD
ECHO THIS BATCH DOES TAKE BACK UP OF THE CURRENT DIRECTORY
ECHO INTO THE UPPER DIRECTORY WITH A TIME STAMP
ECHO FIND ::pause REPLACE pause TO ENABLE DEBUGGING



ECHO SETTING UP THE CURRENT DIRECTORY
set DirName=%CD%
echo DirName is %DirName%
::pause

:: ECHO ADJUST THE DELIMS=. TO THE CHACHATER OF YOUR PROMPT
:: ADD THE DATE STAMP TO THE DIRECTORY NAME
for /f "delims=. tokens=1,2,3" %%i in ('echo %DATE%') do echo off&echo %%i.%%j.%%k
for /f "delims=. tokens=1,2,3" %%i in ('echo %DATE%') do set DirName=%DirName%.%%i.%%j.%%k

echo DirName is %DirName%
::pause

ECHO TOKENS TELLS WHICH ARE THE WORDS TO SPLIT THE 'echo %time%' command
::ADD THE TIME STAMP TO THE DIRECTORY NAME
for /f "delims=: tokens=1,2,3" %%i in ('echo %time%') do echo off&echo %%i.%%j.%%k
for /f "delims=: tokens=1,2,3" %%i in ('echo %time%') do set DirName=%DirName%.%%i.%%j.%%k


echo DirName is %DirName%
:: pause


ECHO BACKUP CURRENT DIRECTORY RECURSIVELY
xcopy /S /E /Y /I "%CD%" "%DirName%"

ECHO PRESS ENTER TO EXIT
pause

Generic database access layer

Would it not be great to have web application which provides generic web layer for the major RDBMS's - Oracle , SQL Server , MySql , Db2 ...etc.

Well So far we are close for SQL Server 2005 ... It is uses C# .Net and does not utilize MVC but its own meta data , GUI generation scheme ...

Sounds interesting ?! Post reply if you are developing something like that !

Google Reader + Opera = most efficient news browsing

I find the flashing and loading of web pages very annoying ... even wiht my 24 Mbit/s broadband and Opera there is always some 0.2 seconds of page loading and page restructuring ...

The answer is Google Reader and Opera configuration to open the pop-ups in the background so :
- load Google reader
- pres n to load all the feeds ...
- start pressing p to go up one be one - if something interesting is found press V - to open it - Opera will force it to open in the background - if you want to see it immidiately press Shift + Ctrl + Tab - it will open the latest open tab
- I do have also often the panels setting for floating , so by pressing F4 I see all the windows and with the arrows start from those I want to read now ...

So this way I am able to review some 2000 news per day and read only those most interesting ones - depending on the time ...

Fire in the neighbourhood

google reader shortcuts

SOURCE
http://www.google.com/help/reader/faq.html#shortcuts

j/k	item down/up	selects the next/previous item in the list
space/shift-space	page down/up	moves the page down/up
n/p	scan down/up	in list view, selects the next item without opening it
o	open/close item	in list view, expands or collapses the selected item
enter	open/close item	in list view, expands or collapses the selected item
s	toggle star	stars the selected item
shift-s	toggle share	shares the selected item
m	mark as read/unread	switches the read state of the selected item
t	tag an item	opens the tagging field for the selected item
v	view original	opens the original source for this article in a new window
shift-a	mark all as read	marks all items in the current view as read
1	expanded view	displays the subscription as expanded items
2	list view	displays the subscription as a list of headlines
r	refresh	refreshes the unread counts in the navigation
shift-n/p	navigation down/up	selects the next/previous subscription or folder in the navigation
shift-x	navigation expand/collapse	expand or collapse a folder selected in the navigation
shift-o	navigation open subscription	opens the item currently selected in the navigation
gh	go to home	goes to the Google Reader homepage
ga	go to all items	goes to the "All items" view
gs	go to starred items	goes to the "Starred items" view
gt	go to tag	allows you to navigate to a tag by entering the tag name
gu	go to subscription	allows you to navigate to a subscription by entering the subscription name
u	toggle full screen mode	hides and shows the list of subscriptions
?	keyboard shortcuts help	displays a quick guide to all of Reader's shortcuts

How delegates work in .Net ( C# example )

SOURCE: Pro ASP.NET 3.5 Server Controls and AJAX Components


Create new Console application in Visual Studio and run with F5 , Step down by clicking on the main method press F9 to set break point and run by F5 again and F11 for each step ...


SOURCE:

using System;
namespace ControlsBook2.Ch05
{



delegate void SimpleMulticastDelegate(int a);

public class DelegateImplementorClass
{
public void ClassMethod(int i)
{
Console.WriteLine("You passed in " + i.ToString() + " to the class method");
}

static public void StaticClassMethod(int j)
{
Console.WriteLine("You passed in " + j.ToString() +
" to the static class method");
}

public void YetAnotherClassMethod(int k)
{
Console.WriteLine("You passed in " + k.ToString() +
" to yet another class method");
}
}


class Program
{
static void Main(string[] args)
{
DelegateImplementorClass ImpClass = new DelegateImplementorClass();
SimpleMulticastDelegate d = new SimpleMulticastDelegate(ImpClass.ClassMethod);
d(5);

Console.WriteLine("");
d += new SimpleMulticastDelegate(DelegateImplementorClass.StaticClassMethod);
d(10);

Console.WriteLine("");
d += new SimpleMulticastDelegate(ImpClass.YetAnotherClassMethod);
d(15);


Console.WriteLine ( "NOW START REMOVING" );
d -= new SimpleMulticastDelegate ( DelegateImplementorClass.StaticClassMethod );
d ( 35 );
Console.WriteLine ( "" );


Console.Read();
}
}
}


101 tips for searching google

Trackball
http://www.techradar.com/news/internet/web/google-week-101-google-tips-tricks-and-hacks-462143

Google search tips

1. The best way to begin searching harder with Google is by clicking theAdvanced Searchlink.

2. This lets you search for exact phrases, "all these words", or one of the specified keywords by entering search terms into the appropriate box.

3. You can also define how many results you want on the page, what language and what file type you're looking for, all with menus.

4. Advanced Search lets you type in a Top Level Domain (like .co.uk) in the "Search within site of domain" box to restrict results.

5. And you can click the "Date, usage rights, numeric range and more" link to access more advanced features.

6. Save time – most of these advanced features are also available in Google's front page search box, as command line parameters.

7. Google's main search invisibly combines search terms with the Boolean construct "AND". When you enter smoke fire – it looks for smoke AND fire.

8. To make Google search for smoke or fire, just type smoke OR fire

9. Instead of OR you can type the | symbol, like this: smoke | fire

10. Boolean connectors like AND and OR are case sensitive. They must be upper case.

11. Search for a specific term, then one keyword OR another by grouping them with parentheses, like this: water (smoke OR fire)

12. To look for phrases, put them in quotes:"there's no smoke without fire"

13. Synonym search looks for words that mean similar things. Use the tilde symbol before your keyword, like this: ~eggplant

14. Exclude specific key words with the minus operator. new pram -ebay excludes all results from eBay.

15. Common words, like I, and, then and if are ignored by Google. These are called "stop words".

16. The plus operator makes sure stop words are included. Like: fish +and chips

17. If a stop word is included in a phrase between quote marks as a phrase, the word is searched for.

18. You can also ask Google to fill in a blank. Try: Christopher Columbus discovered *

19. Search for a numerical range using the numrange operator. For example, search for Sony TV between £300 and £500 with the string Sony TV £300..£500

20. Google recognises 13 main file types through advanced search, including all Microsoft Office Document types, Lotus, PostScript, Shockwave Flash and plain text files.

21. Search for any filetype directly using the modifier filetype:[filetype extension]. For example: soccer filetype:pdf

22. Exclude entire file types, using the same Boolean syntax we used to exclude key words earlier: rugby -filetype:doc

23, In fact, you can combine any Boolean search operators, as long as your syntax is correct. An example: "sausage and mash" -onions filetype:doc

24. Google has some very powerful, hidden search parameters, too. For example "intitle" only searches page titles. Try intitle:herbs

25. If you're looking for files rather than pages – give index of as the intitle:parameter. It helps you find web and FTP directories.

26. The modifier inurl only searches the web address of a page: give inurl:spices a go.

27. Find live webcams by searching for:inurl:view/view.shtml

28. The modifier inanchor is very specific, only finding results in text used in page links.

29. Want to know how many links there are to a site? Try link:sitename – for examplelink:www.mozilla.org

30. Similarly, you can find pages that Google thinks are related in content, using therelated: modifier. Use it like this:related:www.microsoft.com

31. The modifier info:site_name returns information about the specified page.

32. Alternatively, do a normal search then click the "Similar Pages" link next to a result.

33. Specify a site to search with the site:modifier – like this: search tips site:www.techradar.com

34. The above tip works with directory sites like www.dmoz.org and dynamically generated sites.

35. Access Google Directory – a database of handpicked and rated sites – at directory.google.com

36. The Boolean operators intitle and inurlwork in Google directory, as does OR.

37. Use the site: modifier when searching Google Images, at images.google.com. For example: dvd recorder site:www.amazon.co.uk

38. Similar, using "site:.com" will only return results from .com domains.

39. Google News (news.google.com) has its own Boolean parameters. For example "intext" pulls terms from the body of a story.

40. If you use the operator "source:" in Google News, you can pick specific archives. For example: heather mills source:daily_mail

41. Using the "location:" filter enables you to return news from a chosen country.location:uk for example.

42. Similarly, Google Blogsearch (blogsearch.google.com) has its own syntax. You can search for a blog title, for example, using inblogtitle:

43. The general search engine can get very specific indeed. Try movie:to look for movie reviews.

44. The modifier film: works just as well!

45. Enter showtimes and Google will prompt you for your postcode. Enter it and it'll tell you when and where local films are showing.

46. For a dedicated film search page, go to www.google.co.uk/movies

47. If you ticked "Remember this Location" when you searched for show times, the next time you can enter the name of a current film instead.

48. Google really likes movies. Try typingdirector: The Dark Knight into the main search box.

49. For cast lists, try cast: name_of_film

50. The modifier music: followed by a band, song or album returns music reviews.

51. Try searching for weather London – you'll get a full 4-day forecast.

52. There's also a built-in dictionary. Trydefine: in the search box.

53. Google stores the content of old sites. You can search this cache direct with the syntax keyword cache:site_url

54. Alternatively, enter cache:site_url into Google's search box to be taken direct to the stored site.

55. No calculator handy? Use Google's built in features. Try typing 12*15 and hitting "Google Search".

56. Google's calculator converts measurements and understands natural language. Type in 14 stones in kilos, for example.

57. It does currency conversion too. Try 200 pounds in euros

58. If you know the currency code you can type 200 GBP in EUR instead for more reliable results.

59. And temperature! Just type: 98 f to c to convert Fahrenheit to Centigrade.

60. Want to know how clever Google really is? Type 2476 in roman numerals, then hit "Google Search"...

61. You can personalise your Google experience by creating a Google account. Go to www.google.com/account/ then click "Create Account".

62. With a Google account there are lots more extras available. You'll get a free Gmail email account for one...

63. With your Google account, you can also personalise your front page. Click "iGoogle" to add blog and site feeds.

64. Click "Add a Tab" in iGoogle to add custom tabs. Google automatically populates them with suitable site suggestions.

65. iGoogle allows you to theme your page too. Click "Select Theme" to change the default look.

66. Some iGoogle themes change with time..."Sweet Dreams" is a theme that turns from day to night as you browse.

7. Click "More" under "Try something new" to access a full list of Google sites and new features.

68. "Custom Search" enables you to create a branded Google search for your own site.

69. An active, useful service missing from the list is "Personalised Search" – but you can access it via www.google.com/psearchwhen you're logged in.

70. This page lists searches you have recently made – and is divided into categories. Clicking "pause" stops Google from recording your history.

71. Click "Trends" to see the sites you visit most, the terms you enter most often and links you've clicked on!

72. Personalised Search also includes a bookmark facility – which enables you to save bookmarks online and access them from anywhere.

73. You can add bookmarks or access your bookmarks using the iGoogle Bookmarks gadget.

74. Did you know you can search within your returned results? Scroll down to the bottom of the search results page to find the link.

75. Search locally by appending your postcode to the end of query. For exampleIndian food BA1 2BW finds restaurants in Bath, with addresses and phone numbers!

76. Looking for a map? Just add map to the end of your query, like this: Leeds map

77. Google finds images just as easily and lists them at the top, when you add image to the end of your search.

78. Google Image Search recognises faces... add &imgtype=face to the end of the returned URL in the location bar, then hit enter to filter out pictures that aren't people.

79. Keeping an eye on stocks? Typestocks: followed by market ticker for the company and Google returns the data from Google Finance.

80. Enter the carrier and flight number in Google's main search box to return flight tracking information.

81. What time is it? Find out anywhere by typing time then the name of a place.

82. You may have noticed Google suggests alternate spellings for search terms – that's the built in spell checker!

83. You can invoke the spell checker directly by using spell: followed by your keyword.

84. Click "I'm Feeling Lucky" to be taken straight to the first page Google finds for your keyword.

85. Enter a statistics-based query likepopulation of Britain into Google, and it will show you the answer at the top of its results.

86. If your search has none-English results, click "Translate this Page" to see it in English.

87. You can search foreign sites specifically by clicking "Language Tools", then choosing which countries sites to translate your query to.

88. Other features on the language tools page include a translator for blocks of text you can type or cut and paste.

89. There's also a box that you can enter a direct URL into, translating to the chosen language.

90. Near the language tools link, you'll see the "Search Preferences". This handy page is full of secret functionality.

91. You can specify which languages Google returns results in, ticking as many (or few) boxes as you like.

92. Google's Safe Search protects you from explicit sexual content. You can choose to filter results more stringently or switch it off completely.

93. Google's default of 10 results a page can be increased to up to 100 in Search Preferences, too.

94. You can also set Google to open your search results in a new window.

95. Want to see what others are searching for or improve your page rank? Go towww.google.com/zeitgeist

96. Another useful, experimental search can be found at www.google.com/trends – where you can find the hottest search terms.

97. To compare the performance of two or more terms, enter them into the trends search box separated by commas.

98. Fancy searching Google in Klingon? Go to www.google.com/intl/xx-klingon

99. Perhaps the Swedish chef from the muppets is your role model instead? Checkwww.google.com/intl/xx-bork

100. Type answer to life, the universe and everything into Google. You may be surprised by the result...

101. It will also tell you the number of horns on a unicorn

How-to connect to Essbase cube via asp.net and C# - A generic web based report runner

GeSHi © 2004-2007 Nigel McNie, 2007-2008 Benny Baumann, 2008 Milian Wolff

1. <%@ Page Language="C#" MasterPageFile="~/masters/m2.master" AutoEventWireup="true" CodeFile="RunReportDemo.aspx.cs" Inherits="RunReportDemo" Title="Untitled Page" ValidateRequest="false" %>




3. <asp:Content ID="Content1" ContentPlaceHolderID="m2hcph" Runat="Server">




5. link href="css/global.css" rel="stylesheet" type="text/css" />


6. link href="css/RunReportDemo.css" rel="stylesheet" type="text/css" />


7. </asp:Content>






10. <asp:Content ID="Content2" ContentPlaceHolderID="m2bcp" Runat="Server">




12. div id="inputOutputFields">




14. <div class="row" style="margin-left:30px">


15. <asp:Label runat="server" ID="labError" style="margin-left:160px">This
    simple demo demonstrates the running of any report on a local
    essbase server and with locally installed Essbase Deployment Services. Please, remember to write "password"


16. for the password text field without the quotes. You can use the example report scripts on the example Application Databases installed with Essbase 7.1.5 , do not use any other login credentials - e.g. for simplicity only the system account with password are used.


17. </asp:Label>




19. <div class="row" style="margin-left:160px">


20. <a href="please here link to example scripts/test/essbase_scripts/"> click here to copy paste other script examples from the <strong>Demo Basic database</strong></a>


21. </div>




23. <div class="row">


24. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Essbase User Name :</span><span


25. class="formw"> <asp:TextBox ID="txtEssbaseUserName" runat="server" MaxLength="30" Width="170px"


26. ToolTip="Enter your domain name here "></asp:TextBox></span>


27. </div>


28. <div class="row">




30. <div class="row">


31. <span class="label"><span class="asterix"> &nbsp;*&nbsp;</span>Essbase Password ( REMEMBER TO FILL IT IN WITH "password" ):</span><span


32. class="formw"><asp:TextBox id="txtPassword" runat="server" TextMode="Password"


33. MaxLength="30" ToolTip="Enter your password here" Width="169px"></asp:TextBox></span>


34. </div>






37. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> EDS server :</span><span


38. class="formw"> <asp:TextBox ID="txtEDSServer" runat="server" MaxLength="30" Width="170px"


39. ToolTip="Enter the PRS Server here "></asp:TextBox></span>


40. </div>




42. <div class="row">


43. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> OLAP server :</span><span


44. class="formw"> <asp:TextBox ID="txtOLAPServer" runat="server" MaxLength="30" Width="170px"


45. ToolTip="Enter the PRS Server here "></asp:TextBox></span>


46. </div>




48. <div class="row">


49. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Servlet path :</span><span


50. class="formw"> <asp:TextBox ID="txtServletPath" runat="server" MaxLength="70" Width="300px"


51. ToolTip="Enter the PRS Server here "></asp:TextBox></span>


52. </div>




54. <div class="row">


55. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Essbase domain :</span><span


56. class="formw"> <asp:TextBox ID="txtEssbaseDomain" runat="server" MaxLength="30" Width="170px"


57. ToolTip="Enter the PRS Server here "></asp:TextBox></span>


58. </div>






61. <div class="row">


62. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> Application</span><span


63. class="formw"> <asp:TextBox ID="txtApplication" runat="server" MaxLength="30" Width="170px"


64. ToolTip="Enter your domain name here "></asp:TextBox></span>


65. </div>


66. <div class="row">


67. <span class="label"><span class="asterix"> &nbsp;*&nbsp; </span> DataBase</span><span


68. class="formw"> <asp:TextBox ID="txtDataBase" runat="server" MaxLength="30" Width="170px"


69. ToolTip="Enter the PRS Server here "></asp:TextBox></span>


70. </div>




72. <div class="row">


73. <span class="label"><span class="asterix"> &nbsp;*&nbsp;</span>Cube View Name:</span><span


74. class="formw"><asp:TextBox id="txtCubeViewName" runat="server" MaxLength="8000"


75. ToolTip="Enter your Command here" Width="70px" Rows="1"></asp:TextBox></span>


76. </div>






79. <div class="row">


80. <span class="label"><span class="asterix"> &nbsp;*&nbsp;</span> Report To Run :</span>


81. <span><asp:TextBox id="txtReport" CssClass="txtInformer" runat="server" TextMode="MultiLine" MaxLength="8000"


82. ToolTip="Enter your Command here" Width="700px" Rows="10"></asp:TextBox></span>


83. </div>










88. <div class="row">


89. <span class="label"></span><span


90. class="formw"><asp:Button ID="ButLogin" runat="server" OnClick="ClickRunReport"


91. Text=" Login & Run " Width="100px" ToolTip = " Press the button or hit Enter to login to the POC System"/> </span>


92. </div>








96. <div class="row">


97. <asp:TextBox runat="server" ID="txtInformer" MaxLength="25"


98. TextMode="MultiLine" CssClass="txtInformer" Height="600px"


99. ></asp:TextBox>


100. </div>






103. </div>


104. <!-- eof inputOutputFields -->












































126. </asp:Content>




128. ///////////////////////////////////////////////////////////////////// CODE BEHIND ..


129. using System;


130. using System.Collections;


131. using System.Configuration;


132. using System.Data;


133. using System.Linq;


134. using System.Web;


135. using System.Web.Security;


136. using System.Web.UI;


137. using System.Web.UI.HtmlControls;


138. using System.Web.UI.WebControls;


139. using System.Web.UI.WebControls.WebParts;


140. using Hyperion.Objects.Essbase.Common;




142. public partial class RunReportDemo : CustomBasePage


143. {


144. #region TemplateMethods


145. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     TEMPLATE METHODS START






148. protected override void OnInit(EventArgs e)


149. {


150. base.OnInit(e);




152. } //eof OnInit






155. protected override void CreateChildControls()


156. {


157. base.CreateChildControls();


158. CreateDynamicControls();


159. }






162. protected override object SaveViewState()


163. {


164. return new Pair(base.SaveViewState(), null);


165. }




167. protected override void LoadViewState(object savedState)


168. {


169. base.LoadViewState(((Pair)savedState).First);


170. EnsureChildControls();


171. }






174. protected void Page_Load(object sender, EventArgs e)


175. { //comm -- the controls should be generated at the init stage and the databinding happens here








179. if (Page.IsPostBack == false)


180. { //comm -- databindings here


181. //this.DataBind ( );


182. } //eof if(Page.IsPostBack == false)


183. } //eof Page_Load






186. //////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     TEMPLATE METHODS END


187. #endregion //TemplateMethods






190. #region CreateDynamicControls


191. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     CREATE DYNAMIC CONTROLS START


192. private void CreateDynamicControls()


193. {


194. //set the default values so that the users should not be quessing and copy pasting


195. this.DisplaySetDefaults();


196. string echo = (string)Session["RunReport.echo"];


197. //run the query




199. if (this.IsPostBack)


200. {










205. } //eof if ( this.IsPostBack )






208. } //eof CreateDynamincControls




210. /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     CREATE DYNAMIC CONTROLS END


211. #endregion CreateDynamicControls






214. #region DisplayMethods


215. ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     DISPLAY METHODS START






218. private void DisplaySetDefaults()


219. {


220. txtEssbaseUserName.Text = "your_configured_user_name";


221. txtPassword.Text = "your_configured_pass";


222. txtServletPath.Text = "http://localhost:8080/EssbaseObjects"; //or whatever


223. txtEDSServer.Text = "localhost";


224. txtEssbaseDomain.Text = "essbase";


225. txtOLAPServer.Text = "localhost";


226. txtApplication.Text = "Samppart";


227. txtDataBase.Text = "Company";


228. txtCubeViewName.Text = "default";


229. txtReport.Text = "{TABDELIMIT}" +


230. "add here your report!";




232. } //eof method DisplaySetDefaults




234. private FB.CubeTransaction FromScreenToObj(ref string echo)


235. {




237. FB.CubeTransaction ct = new FB.CubeTransaction();




239. try


240. {


241. ct.UserName = txtEssbaseUserName.Text;


242. ct.Password = txtPassword.Text;


243. ct.ServletPath = txtServletPath.Text;


244. ct.ReportString = txtReport.Text;


245. ct.EDSServer = txtEDSServer.Text;


246. ct.EssbaseDomain = txtEssbaseDomain.Text;


247. ct.OLAPServer = txtOLAPServer.Text;


248. ct.Application = txtApplication.Text;


249. ct.DataBase = txtDataBase.Text;


250. ct.CubeViewName = txtCubeViewName.Text;


251. ct.ReportString = txtReport.Text;


252. //TODO : add input check here


253. return ct;


254. }


255. catch (Exception e)


256. {


257. echo = echo + "An exception ocurred while retrieving the values ! " +


258. "Report to Advanced Application Suport the following error : \n" + e.Message;


259. return null;


260. } //eof catch










265. } //eof FromScreenToObj










270. private void DisplayResults(ref string msg, ref string echo)


271. {


272. txtInformer.Text = echo;


273. labError.Text = msg;


274. } //eof DisplayResults






277. ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
     DISPLAY METHODS END


278. #endregion DisplayMethods








282. #region DataMethods




284. private void RunReport(ref string msg, ref string echo)


285. {


286. FB.CubeTransaction ct = (FB.CubeTransaction)Session["RunReport.ct"];


287. HES.CubeWrapper cw = new HES.CubeWrapper();


288. cw.RunReport(ref msg, ref echo, ref ct);




290. } //eof RunQuery




292. #endregion //DisplayMethods








296. #region ClickEventHandlers




298. protected void ClickRunReport(object sender, EventArgs e)


299. {


300. string msg = String.Empty;


301. string echo = String.Empty;




303. //get the values into the bean


304. FB.CubeTransaction ct = this.FromScreenToObj(ref echo);


305. Session["RunReport.ct"] = ct; //store them for the PostBack


306. Session["RunReport.echo"] = null;


307. Session["RunReport.echo"] = echo;




309. this.RunReport(ref msg, ref echo);


310. this.DisplayResults(ref msg, ref echo);






313. } //eof method ClickButLogin


314. #endregion //ClickEventHandlers




316. } //eof class RunReport