Recently the Essbase CDF sample code was moved and I thought it would be a good idea to let every one know where the new code can be found.
http://www.oracle.com/technetwork/indexes/samplecode/essbase-sample-522117.html
or
Click Sample Code Index on the left
Click on Essbase
5 comments:
http://essbase.ru/archives/322
Dear Milella, could you please help me to build the syntax for the below requirement, I need to load data using a business rules using the @JsetValuesFromFile(filename,pages,rows,cols,setValues,startAtLine, quotes, caseInSens, colDelim,pageIdent)
my file contains below records
product Function Entity Currency Account Jan
AP8331_PRD AU01300047 AU AUD_DocCurr 8205_ACT 3864.1
And FIX on current_forecast, version
Can you please help me to understand how to use this function
thank you for your help.
Leo
Sample script looks like this:
Fix (@LEVMBRS("Market",0),@LEVMBRS("Measures",0),"100-10","Jan")
Import_Actual (
@JSetValuesFromFile("c:/Sales_Actual.txt",
@LIST(@NAME(@CURRMBR("Market")),@NAME("Actual"),@NAME(@CURRMBR("Measures"))),
@NAME(@LEVMBRS("Product",0)),
@NAME("Jan":"Dec"),
@SETVAL(@LEVMBRS("Product",0)->"Jan":"Dec"),
1,
@_False,
@_True,
"tab",
"tab");
)
EndFix
Data file layout looks like this:
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Illinois Actual Sales
100-10 4860 4821 4904 5048 5252 5748 5959 6014 5325 4902 4817 5174
What release were CDF's first made avialble? Was it in late 2007/early 2008? Thanks - Angie Wilcox
CDFs have been around since about the 2001-2002 timeframe.
Post a Comment