Export and/or product migration of Essbase

All of us must have heard out the Outline Extractor. There is another tool which helps us to take the Essbase backup.
CubePort, a commercial conversion application, converts Essbase cubes to the Microsoft SQL Server Analysis Services product. This product performs an object-to-object translation that make up an Essbase cube, including: outline, member formulas, calc scripts, data loading (load rules), report scripts to MDX queries, substitution variables, and security model. It can extract from any platform version of Essbase, including Oracle/Hyperion Essbase on Windows, Unix, AIX, HP UX, Solaris, IBM DB/2 OLAP, or AS/400 Showcase Essbase.

Parse Error in EPMA

Quite busy for the past few week...
This post is regarding  parse error in EPMA.
I was trying to create EPMA Planning app in 11.1.2.1 was getting " parse error" While importing the ADS file....

Possible Solution :
------------------
Check the Pipe count (the count should be n-1 of the total no. of header col)

IE7 Vs IE8

Today i have an interesting stuff to share which is related to session cookies.
 "How Browsers (IE7,IE8) manages request".
Major architectural changes happend IE8. which are very interesting like Loosely-Coupled IE,Automatic Crash recovery
Doing some testing on how reliable this new techniques are?
Learnt some of the new techniques like Frame Process Merging/ Session Sharing.

based on the research what i found was 

1) IE7 cannot create a NEW SESSION for each tab.
2) But MS claims that in IE8 there is an option for -nomerge which can create NEW SESSION for each tab.Need to check !!!!


Check out the MS KB for more info..................

Questions:-

1) If IE is not able to manage the session cookies properly how will it destroy the cookies ?

2) If Browsers are not able to manage the cookies properly then all the web based designers applications wont work properly.So what is the work around ?

Really interested to see how Mozilla and other browsers are handling this kind of issue.

killing a process from a guest account / Limited Power Account

Some time back had a discussion  with one of my close friend the discussion was regarding
1) How will you kill a process from a Guest Account?
2) How will you list out all the process that are running on your machine from a guest login ( Using Windows Command Line ) ?
 Dont knw y he had this kinda Q :-P


Guest Login

1) It is not possible to kill a process (which is initiated by other user)  from a Guest account.
2) It is not possible to list the process that are running on your machine from a Guest Login

Admin Login

1) To list the process that are running on your machine


Command Line :
1) tasklist /svc  will list even the service name

Command Line:
2) tasklist

2) To forcefully kill a process
taskkill /F  /PID < >

Note : Dont try this in ur prod ;-)

Learn FDQM

Soon will be posting my learnings on FDQM

Simple Data Export Calculation Script

Example 1:

SET DATAEXPORTOPTIONS
{
DataExportColFormat ON;
DataExportOverwriteFile ON;
DataExportColHeader "Measures";
};

FIX ("Actual","100-10");

DATAEXPORT "File" "," "C:\Exports\export.txt";

ENDFIX

Example 2:

/* Turn off Intelligent Calculation. */
SET UPDATECALC OFF;
SET CACHE HIGH;

Fix("dim1",@RELATIVE("dim2-member",0),"dim3","dim5-member","dim4","Current",@RELATIVE("YearTotal",0))

SET DATAEXPORTOPTIONS
{
DataExportNonExistingBlocks ON;
DATAEXPORTDIMHEADER ON;
DataExportOverwriteFile ON;
DataExportColHeader "Periods";
};




FIX("ThisYear","Forecast","Prod-dim",@ICHILDREN("Entity-dim"),"dim6")
/* Actual data*/

DATAEXPORT "File" " " "/hypadmin/Store/ActualData_Export.txt" "NULL";



ENDFIX

FIX("CurrectYear","Forecast","Prod-dim",@ICHILDREN("Entity-dim"),"dim6")
/* Forecast data*/

DATAEXPORT "File" " " "/hypadmin/store/forecastData_Export.txt" "NULL";

ENDFIX

FIX("CurrectYear","Budget","Prod-dim",@ICHILDREN("Entity-dim"),"dim6")
/* Budget Data*/

DATAEXPORT "File" " " "/hypadmin/store/BudgetData_Export.txt" "NULL";

ENDFIX


ENDFIX