Automatic processing of SSAS cubes

I needed to automate the process of refreshing my Sql Server Analysis Services Cubes. My SQL server is 2000 and Analysis Services is SP4.

The approach I followed today is as follows:

I created a package in DTS of SQL Server 2000

Step 1 Created a SSAS task and pointed the Dimension (Rebuild the dimension) that needs to be updated.

Step 2 Then I created another task to refreshh all cubes.

Step 3 I created a On Success workflow between the above two tasks.

I saved this package and scheduled it to run monthly.

Displaying Temporary Internet Files folder in Windows Explorer

I am so used to browse the temporary internet files folder for internet exploer but I was not able to do this since I upgraded my Internet Exploer to 7. I finally found a way to do this. Microsoft has made the temporary internet files folder a 'Protected operating system folder'. That is the reason we cannot view that folder even when we check on the option 'Show hidden files and folders'.

All we have to do is Go to Windows Explorer -- Tools -- Folder options -- View tab
Untick the 'Hide protected system files and folders'

And you can see the Temporary internet files' folder in C:\Documents and Settings\User\Local Settings\ folder.

Java based math course includes problem-solving lessons and tests

Visual and interactive way to thorough understanding and mastering Trigonometry without getting wearied on the very first chapter! Java- and web-based math course includes theoretical

read more

Concatenate values from two text box and populate the value in another text box

Today I had to create a function to concatenate two values from a text box and populate the output in another text box. This I did to inmprove the usability of the form for inputing the credit card data.

This is what I wrote



function conc()
{
var mon;
var yy;

yy=document.getElementById("Texty").value;
mon=document.getElementById("Textm").value;
document.getElementById("Texte").value=yy+mon;
}

Web Photo Gallery with Photoshop

Today I was googling for some CSS photo gallery that I want to use for my website. I found quite interesting ones as follows:

Library of CSS Stylesheets
Joshuaink Photo Gallery Template
http://www.cssplay.co.uk/menu/lightbox.html

The one that suited me was described in this chapter on Techrepublic.

As I was about to call off my search, I found this easy way of creating a photogallery using Photoshop CS2 which is really handy if you have to create a photo gallery out of many photos.

How to Create an "Invisible" Folder for Your, um, "Private" Files

You ever have a folder on your computer that you really dont want any one to find? You can make this folder hidden but then you have to un-hide all the folders when ever you want to find it. So how can you make a folder truly invisible? Follow these simple steps and your unmentionables will stay that way

read more

My first project in c# ASP.net

Today for the first time I created a project in ASP.net. All this while I was doing some modifications for SQL code and reports for existing .NET projects. I wanted to recreate the functionality described here

When I did exactly what was said and tried to access the webpage, I got the error "Code not parsed...." When I googled for this error, then only I realised that I did not build the solution. So the error was fixed when I compiled the project.

Problems with connecting to proxy

Wayne, our systems Administrator contributed this:

Having problems with a user who cannot connect to our proxy server because their Internet Explorer keeps using a manually entered username and password, instead of their domain username and password. Even typing in the correct username and password doesn't work. Tried resetting IE settings, changing authentication options, with no success. Finally found instructions on removing the saved passwords, and that fixed the problem.

Windows XP does not offer a very easy way to review or remove the saved passwords though. If you follow the steps below though you can access a graphical interface to add, remove or edit the saved passwords on a given system.

1. Click Start and select Run

2. In the Open field type "rundll32.exe keymgr.dll, KRShowKeyMgr"

3. Once the Stored Usernames and Passwords interface opens you can select any of the entries and select Properties to view the existing information

4. To remove a saved password you can select one of the entries and select Remove. A confirmation screen will appear. Click on OK and the account will be removed

5. You can add additional saved passwords as well by clicking on the Add button and entering the appropriate information

6. Repeat the steps above as needed to add, remove or edit saved passwords

7. When you are done using the interface click the Close button

Thanks Wayne, for your contribution.

12 Ways to Make Better Use of Your Footer

Great list of ways to use an extended footer on a blog, and why you should move stuff down there as opposed to cluttering up your sidebar.

read more

Lists: To Do vs Action vs Next Action

Here is an interesting article on how to make your To Do list that works. Read More

Use SQL subselects to consolidate queries

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro!

read more | digg story

Messy Code? Stumped? Submit it to be refactored @ refactormycode.com

Have you got a method that you're dying to simplify? A class that's growing out of control? Or an algorithm that you just can't get working? Submit it to the new, awesome web app Refactor My Code, and have it refactored.

read more

The Flash Blog - Some great examples of Flash UI development

It seems as though Lee Brimelow is from Adobe. He is somehow connected to gotoandlearn.com, which has a lot of awesome tutorials on how these sites are made. Good site to check out if you're into flash UI dev. Cool stuff, check it out.

read more

Prompt for downloading word documents

I have created a functionality that will allow the users to download a pdf or a word document. The download was working fine when I used it, but on another machine I noticed that the prompt for download that asks the user whether to open or save the word file was not appearing.

These are the steps you need to follow when you are faced with this problem.

Go to the windows explorer,
Choose Tools-- Folder options
Click on File Types tab
Choose file type 'DOC' for word, 'PPT' for Powerpoint etc.
Click on the Advanced botton
Make sure that the "confirm open to download" checkbox is ticked.

Hope you enjoy it.

Wondershare Flash Album Studio v1.8.0

Looking for a new exciting way to show off your photos? Amaze your friends by taking them into the stunning flash photo galleries with Wondershare Flash Album Studio.

read more

Flash Effect Maker Pro v3.5 w / 578 Templates

Flash effect Maker is the great Flash effect tool to help webmaster design animated Flash intros, Flash banners, Flash ads, and any other Flash. With Flash effect Maker you can place your own photos as font front ground and page background. And then combine them with animated text, background effect to create fun Flash movies, all in just minutes.

read more

Mp3Resizer v1.8.3

Mp3Resizer is created to optimize the capacity of your portable music player by reducing the size of mp3 files. This is especially useful when listening to MP3 files or MP3 Audio books on a mobile phone, MP3 player, Pocket PC, etc.

read more |

Ajax Utilities

Here are more than 150 ajax utitlity with full description about each utility

read more

Unable to enlist in the transaction

Today after about a month again I was facing a similar problem of unable to enlist a transaction. I took half a day, to realise that this is the problem as there was no error when I was using the web interface but the results were not coming up. Then I slowly started looking at the event viewer and only then I noticed the "Unable to enlist a transaction error". I didnot expect the reason for this until I read this article, When I disconnected the firewall everything seems working well. I have now switched the firewall back on by allowing the port for MSDTC as 3372.

document.getElementId() has no properties

Today I was getting this error, in Firefox even though the Javascript code that I wrote was working fine.

I had a feeling that my javascript code was not working, and concentrated to work on that.

But the error was not in the javascript code but in the xsl code.

To solve these kind of errors in FF give your elements IDs instead of names and reference them with

document.getElementById("id")

IE seems to be a bit relaxed even though you have a name defined and not the Id.