How to copy directories alone from one directory to other

find . -type d  -depth | cpio -dumpl "Target directory path"

-depth : Always true. Causes descent of the directory hierarchy to  be  done  so  that  all entries in a directory are acted on before the directory  itself.   This  can  be useful  when  find  is  used  with cpio(1) to transfer files that are contained in directories without  write

permission.

cpio: copy files to or from archives.

Options : d : Creating a leading directories when needed.

              u : Unconditional

             m : preserve time, modifications

               l : link files

              p : In copy-out mode, cpio copies files into an archive. It reads a list of filenames, one per line, on the standard input, and writes the archive onto the standard output. A typical way to generate the list of filenames is with the find command; you should give find the -depth option to minimize problems with permissions on directories that are unreadable.

         

Why do elephants ears so big

The big ears are to help the elephants to stay cool, Elephants skin is very hard and it doesn't sweat, so to maintain the body heat elephants use their ears as Coolers, as at ears many of the blood vessels accumulated, there the exchange of heat taken place.

My right mouse pop up no longer works in Excel?

When ESSBASE/Excel add-in is installed , the default behavior is for ESSBASE to "take over" your right mouse click.
This is because the Excel add-in provides for some additional ESSBASE functionality, the problem is that it is installed without your knowledge.
To regain the control of your right mouse pop up menu in Excel:

How fetch slice of data from one database to other database

We can fetch a slice of data from one database to other database using XREF function which intern using Location Aliases,

Here is small information how to use @XREF function in calculation script and Location Aliases in ESSBASE.

How to do variance reporting in ESSBASE

Variance reporting property determines how ESSBASE calculates the difference between Actual and Budget data members,
The dimension should be tagged as Account then only variance reporting property becomes visible.
The member formula to calculate the variance reporting between Actual and Budget should consists either of @VAR or @VARPER
There are two types of variances

•        Expense Reporting
•        Non Expense Reporting.

What is Time Balance property in ESSBASE

Time Balance property is one of the hidden property in ESSBASE which comes into picture when you tag any dimension as a Accounts.
If an account dimension member uses the time balance property,it affects how ESSBASE calculates the parent of the member in Time dimension.
ESSBASE has three kind of TB properties:

• TB First
• TB Last
• TB Average

Know more about each file in ESSBASE

As soon as an application created in Essbase, the Analytical Services will creates different files such as Page file(.PAG), Index file (.IND) etc and each files stands for some specific purpose.
All these files are available at $ARBORPATH/app/application/database folder
.otn file (Outline file) : The files consists compile code for the outline hierarchy, member formula, Attributes and Aliases and others.

Crazy bugs in Windows

Few bugs in windows which are funny and can't be explained by the Microsoft whole team, including Bill Gates!!!!!!

An Indian found that nobody can create a FOLDER anywhere on the Computer which can be named as "CON". This is something funny and inexplicable? At Microsoft the whole Team, couldn't answer why this happened! TRY IT NOW, IT WILL NOT CREATE A "CON" FOLDER