|
More site info...
Oracle Essbase
| Forum profile
|
|
Forum profile page for Oracle Essbase
on http://www.oracle.com.
This report page is the aggregated overview from a single forum: Oracle Essbase
, located on the Message Board at http://www.oracle.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Oracle Essbase
" on the Message Board at http://www.oracle.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Oracle Essbase
:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
220
|
554
|
1,607
|
|
Post:
|
485
|
1,266
|
3,858
|
|
|
Oracle Essbase
Posting activity graph:
|
Top authors during last week:
user's latest post:
Cube Size
Published (2009-12-16 23:59:00)
Everything you need to know is here > http://download.oracle.com/docs/cd/E12825_01/epm.111/esb_dbag/launch.htm Just search for block size or sizing etc Cheers John http://john-goodwin.blogspot.com/
user's latest post:
Starting services - what do you do?
Published (2009-12-16 16:29:00)
I'm not an infrastructure guy, so I'll ask the group. In a multiple server windows environment, what do you do to insure that the services are started correctly? For instance shared services before Essbase or EAS, etc. Asume Shared services EAS and Essbase (and FR/ workspace/Web analysis) are on differnt servers.
user's latest post:
Data File Cache Vs buffered I/O
Published (2009-12-16 06:46:00)
Hi, Data file cache comes into picture, only when your setting is ' direct IO'. Its in the DBAG too. Sandeep Reddy Enti HCC http://hyperionconsultancy.com/
user's latest post:
How to use the admin user...
Published (2009-12-09 22:44:00)
HI Mondal, Are you scheduling the reports, if so create another user with required/necesasry access and use that credentials to schedule the report. regards
user's latest post:
Starting services - what do you do?
Published (2009-12-16 18:51:00)
You can use the sc command. It's really pretty cool. See: http://www.windowsnetworking.com/kbase/WindowsTips/WindowsNT/AdminTips/Services/StopStartPauseServicesRemotely.html On my Vista (oh, how I curse it) laptop, I have SC. I am guessing that real Windows O/S's have it too. Here's the output from typing SC from the command prompt: DESCRIPTION: SC is a command line program used for communicating with the Service Control...
user's latest post:
MDX member names
Published (2009-12-15 13:17:00)
I use report scripts to export to text files, then import to Informatica, manipulate and then spit out another text file. I don't use MDX to export data. If you want to get it into a txt file, you would execute the MDX via a MaxL script and use the spool command to write the results to the text file. You would then have to parse the file because the spool command will result in some other content winding up in the file. Again, I think...
user's latest post:
Cannot see ESSBASE application...
Published (2009-12-15 15:11:00)
One note of caution on this. I had to do this and found that sometimes the compression gets set to none. I was pretty surprised when I ran a routine calculation and suddenly got a message from the admin saying we'd run out of disk space, and saw that we had 16 2gb pag files (should be 2). Check your compression settings. Sabrina
user's latest post:
Security filter issue in...
Published (2009-12-16 06:12:00)
can we do this in essbase ? plz can any one hepl on this Edited by: user98631 on Dec 16, 2009 9:52 PM
|
|
|
|
Latest active threads on Oracle Essbase
::
Started 1 day, 4 hours ago (2009-12-17 00:52:00)
by user10658340
HI,
do you work out this problem. I met the same one.
LANG=en_US
LC_ALL is null
ESSLANG=SimplifiedChinese_China.MS936@Binary
Thank you.
Started 1 day, 3 hours ago (2009-12-17 01:22:00)
by 637223
Note : Make sure that you have complete backup of everything
Now try the following:
1) Get essbase.sec from 2 weeks ago or the time it was working
2) Replace openLDAP files (bdb) from the same time frame
3) Replace HSS db with that backup from the same timeframe (the relational database)
4) Run synopenLDAP
5) Run refresh from hss in essbase
6) Test...
Started 1 day, 4 hours ago (2009-12-17 00:44:00)
by JohnGoodwin
Sorry can you expand on what you are actually trying to do, which database connections?
Cheers
John
http://john-goodwin.blogspot.com/
Started 1 week, 1 day ago (2009-12-10 05:01:00)
by DrFosterMan
I think the reason why TIME is showing as #NOACCESS is because you need to include it in the filter deinfition. Try this:
Read - @REMOVE(@IDESC("TIME"),"2005 Actuals")
However if 2005 is the first member below TIME you may not get a value anyway.
Started 1 day, 16 hours ago (2009-12-16 12:18:00)
by GlennS_2
If the two cubes are the same, you could just select the Idescendants of your smallest dimension for both the source and target. /You would not need to put anything on the mappings tab.
I will say partitioning is probably not the qucikest way to copy a cube. If they are on the same server, just use an application copy either through EAS or Maxl. The MaxL ...
Started 3 days, 23 hours ago (2009-12-14 05:56:00)
by GlennS_2
I have created folders within the database folder (like backup) where I copied all of the calc scripts and rules files and have never had a problem.
Started 1 day, 10 hours ago (2009-12-16 18:10:00)
by hjohnson
You can write one startup / shutdown script that controls all hyperion services across multiple servers.
Just list them in the proper order and don't forget to add some pause statements between the services.
hj
Started 1 day, 5 hours ago (2009-12-16 23:59:00)
by JohnGoodwin
Everything you need to know is here > http://download.oracle.com/docs/cd/E12825_01/epm.1 11/esb_dbag/launch.htm
Just search for block size or sizing etc
Cheers
John
http://john- goodwin.blogspot.com/
Started 2 days, 9 hours ago (2009-12-15 19:10:00)
by cl
Do you mean Recovering from a Crashed Database and/or Troubleshooting Essbase Errors ?
These are pretty much it as far as recovering from an error.
Regards,
Cameron Lackpour
Started 1 day, 4 hours ago (2009-12-17 00:23:00)
by JohnGoodwin
Some posts that may be of use to you
http://forums.oracle.com/forums/thread.jspa?messag eID=3497558
http://forums.oracle.com/forums/thread.jspa?messag eID=3411466
Cheers
John
http://john-goodwin.blogspot.com/
|
|
Hot threads for last week on Oracle Essbase
::
Started 1 week, 1 day ago (2009-12-09 13:10:00)
by GlennS_2
Can you paste the actual maxL command? It looks like a path issue in the script.
Started 1 week, 1 day ago (2009-12-10 05:01:00)
by DrFosterMan
I think the reason why TIME is showing as #NOACCESS is because you need to include it in the filter deinfition. Try this:
Read - @REMOVE(@IDESC("TIME"),"2005 Actuals")
However if 2005 is the first member below TIME you may not get a value anyway.
Started 1 week, 1 day ago (2009-12-09 19:37:00)
by Manoj G
Have you increased the timeout setting in AAS ->Hyperion Provider Servers ->Server Name ->Edit ->Properties?
Started 1 week, 2 days ago (2009-12-09 00:05:00)
by JohnGoodwin
This question gets covered so many times, if you do a search you will find all the answers.
In summary use the migration wizard in EAS to migrate the applications, you will need to export your data and import into the new environment.
Cheers
John
http://john- goodwin.blogspot.com/
Started 3 days, 4 hours ago (2009-12-15 00:34:00)
by Sandeep Reddy
Hi Razeesh,
1. 256 columns was not a essbase excel add in constraint , but its of 2003 microsoft excel limitation,as it has 65,536 row limitation.
2. Coming to 2007, they have increased number of possible columns from 256 to 16384 ,so should be able to retrieve more columns technically. I dont see it as excel add in issue again. But i have not checked ...
Started 1 week, 1 day ago (2009-12-09 06:40:00)
by GlennS_2
#invalid is for use with slowly changing attributes. If an intersection does not make sense As example Bob was never the product manager for Colas, then #invalid shows.
Started 6 days, 21 hours ago (2009-12-11 07:48:00)
by JohnGoodwin
Hi,
It is now stored in the HSS registry database.
Cheers
John
http://john-goodwin.blogspot.com/
Started 6 days, 18 hours ago (2009-12-11 10:37:00)
by JohnGoodwin
Hi,
Just start a Maxl (essmsh) session from a command line, log into the essbase server and then paste the MDX;
e.g.
Loging admin password on localhost;
SELECT Year.Qtr1.Level.Members ON COLUMNS, Product.Levels(0).Members ON ROWS FROM Sample.Basic;
Ok?
Cheers
John
http://john-goodwin.blogspot.com/
Started 1 week, 1 day ago (2009-12-09 08:37:00)
by SabrinaD
I dealt with this sort of thing by creating a second, dynamically calculated member that would perform the average. In my case, "Project" is the dimension where I need to see an average of Gross Profit % at upper levels.
IF(@ISLEV("Project",0))
"Gross Profit %";
ELSE
@AVGRANGE(SKIPBOTH,"Gross Profit %",@RELATIVE(@CURRMBR("Project"),0));
ENDIF
...
Started 1 week, 1 day ago (2009-12-10 01:45:00)
by user11107768
Hi.
Close EXCEL.exe from task manager and open excel again... this may solve this problem.
Thanks,
|
|
Size: 427 bytes
