Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Essbase

Discussion List

  • Tim Faitsch-92459
    OLE Error
    Summary OLE ErrorContent One of my users is getting the following error when performing a refresh with Smart View: "Microsoft Excel is waiting for another application to…
    Received Response
    Tim Faitsch-92459 27 views 3 comments Most recent by Tim Faitsch-92459
  • Ruthvik
    FIX on Temporary Variables Error
    Summary FIX on Temporary Variables ErrorContent Hi, I want to FIX on temporary variables defined in the below Calc Script. FIX(@RELATIVE(PROJECT, 0), @RELATIVE(POSITION,…
    Received Response
    Ruthvik 22 views 11 comments Most recent by Ruthvik
  • pr144
    Pass spool path to Maxl
    Summary Pass spool path to MaxlContent How can I pass log path to MaxL login $1 $2; spool on to 'c:\mxlouts\pstatsouts.txt'; I tried passing "'c:\mxlouts\pstatsouts.txt'…
    Received Response
    pr144 15 views 4 comments Most recent by TimG
  • Mickey Green-90322
    ASO Allocation Process too large
    Summary ASO Allocation Process too largeContent I'm attempting to use an allocation process to implement the FX translation approach outlined here: Cameron's Blog For Es…
    Received Response
    Mickey Green-90322 20 views 3 comments Most recent by TimG
  • Sarmadnisar
    Essbase Configuration settings
    Summary Essbase Configuration settingsContent Hi, where can i find the list of settings allowed in essbase.cfg file.... e.g. i can't find QUERYRESULTLIMIT in oracle docu…
    Received Response
    Sarmadnisar 24 views 10 comments Most recent by John Goodwin-95056
  • Alvaro Duqueestrada
    ASO Aggregation Issues with FX Conversion Member Formulas
    Summary ASO Aggregation Issues with FX Conversion Member FormulasContent Dear Essbase community, We are having issues with a currency conversion member formula where USD…
    Received Response
    Alvaro Duqueestrada 75 views 3 comments Most recent by Alvaro Duqueestrada
  • Teddd
    Server Domain Migration Question
    Summary Server Domain Migration QuestionContent Hi, Our IT has decided to do a domain migration an all our servers. In the new world the old FQDN and the new FQDN will b…
    Received Response
    Teddd 15 views 1 comment Most recent by John Goodwin-95056
  • Prapulla Yarlagadda06
    Inability to use right click function for copy/paste or insert the rows
    Summary Inability to use right click function for copy/paste or insert the rowsContent Hi Hyperion Gurus, I am facing the below issue with smart view 11.2.5.500 version.…
    Received Response
    Prapulla Yarlagadda06 34 views 1 comment Most recent by USER1211
  • Ramesh Bandi-92994
    Not able to connect smartview
    Summary Not able to connect smartviewContent Hi, I am trying to connect smartview which I am giving (URL,POrtnumber ,server NAme etc..) everything is ggod ,earlier it wa…
    Received Response
    Ramesh Bandi-92994 16 views 5 comments Most recent by John Goodwin-95056
  • Spl Gowtham
    Error in SmartView
    Summary Error in SmartViewContent Cannot Connect to Essbase Server at [ServerName:1423], Network error[10061] Failed to connect to [ServerName:1423] Do you want to Conne…
    Received Response
    Spl Gowtham 33 views 3 comments Most recent by Sh!va
  • Skvkskvk
    Extract data from ASO cube
    Summary Extract data from ASO cubeContent Hi All, I am trying to extract the data from ASO cube using Report script. I have like 100's of accounts some of which are Dyna…
    Received Response
    Skvkskvk 33 views 7 comments Most recent by USER1211
  • Pragati Dalawai
    Provision and auditing user information
    Summary Provision and auditing user informationContent Hi all, we have provisioned MSAD user in shared services with provision manager role in essbase. Two days later us…
    Question
    Pragati Dalawai 22 views 0 comments Most recent by Pragati Dalawai
  • Spl Gowtham
    SmartView error.
    Summary SmartView error.Content Cannot Connect to Essbase Server at [ServerName:1423], Network error[10061] Failed to connect to [ServerName:1423] Do you want to Connect…
    Question
    Spl Gowtham 32 views 0 comments Most recent by Spl Gowtham
  • Vijaya Kumar Kasireddy
    HsAlias Function
    Summary HsAlias FunctionContent Hi All, In the the below screen shot , HsAlias function(=HsAlias($D$3|$C$5|$D$5) is not working , please help me.
    Question
    Vijaya Kumar Kasireddy 17 views 0 comments Most recent by Vijaya Kumar Kasireddy
  • Ruthvik
    Cross-dimensional member value in IF Statement Error
    Summary Cross-dimensional member value in IF Statement ErrorContent Hi, I trying to create a Calc Script something like below and instead of using "510002"(it's an accou…
    Received Response
    Ruthvik 23 views 10 comments Most recent by Ruthvik
  • Hetatoprani
    Next Month
    Summary Next MonthContent Hello, I have a substitution variable CurFcsMth ( for current month forecast). I have a need in the my calc script to use &CurFcsMth and then h…
    Question
    Hetatoprani 21 views 0 comments Most recent by Hetatoprani
  • Rajneesh75
    Java api to get Cluster name from essbase application name
    Summary Java api to get Cluster name from essbase application nameContent Hello Can anyone point me to if/any Java API that I can use to get cluster name( e.g.. EssbaseC…
    Question
    Rajneesh75 16 views 0 comments Most recent by Rajneesh75
  • SAW23321
    How to populate an Excel worksheet with output from HypQueryMembers function
    Summary How to populate an Excel worksheet with output from HypQueryMembers functionContent Hi. I'm trying to get the children of a member without having to do an ad-hoc…
    Question
    SAW23321 7 views 0 comments Most recent by SAW23321
  • user636464
    SmartView Cascade question
    Summary SmartView Cascade questionContent Hi, would appreciate your feedback to an Oracle EPM 11.1.2.4/SmartView 11.1.2.5.700 related issue we currently face: running a …
    Received Response
    user636464 10 views 1 comment Most recent by USER1211
  • Michael Dewis
    Essbase ASO Cube Converting Dimension to Multiple Hierarchies Enabled
    Summary Essbase ASO Cube Converting Dimension to Multiple Hierarchies EnabledContent Hi All, We have a dimension in an ASO Essbase cube that has always been set up as a …
    Received Response
    Michael Dewis 19 views 6 comments Most recent by GlennS_3
  • Vicki Pannell
    Problem with Smart View Submit Data
    Summary Problem with Smart View Submit DataContent We are implementing Enterprise Planning and Budgeting Cloud, using Smart View to create data-entry templates for non-l…
    Question
    Vicki Pannell 16 views 0 comments Most recent by Vicki Pannell
  • Sri Mannava1234
    Problem with Submit data from smartview
    Summary Problem with Submit data from smartviewContent Hello Experts, We have one planning EPMA application. One of my user having a problem submitting data(Data is not …
    Received Response
    Sri Mannava1234 35 views 2 comments Most recent by Sri Mannava1234
  • Rajneesh75
    The nonemptytuple hint cannot to be processed for member
    Summary The nonemptytuple hint cannot to be processed for memberContent Hello I see this message in essbase log ( version 11.1.2.3.500) The nonemptytuple hint cannot to …
    Received Response
    Rajneesh75 10 views 2 comments Most recent by Rajneesh75
  • Jabbar Jameel
    Refresh all worksheet option for hidden sheets
    Summary Refresh all worksheet option for hidden sheetsContent Why refresh all worksheet is not refreshing hidden worksheets in excel ? I'm using smartview 11.1.2.5.610 o…
    Question
    Jabbar Jameel 37 views 0 comments Most recent by Jabbar Jameel
  • Mmavs Seeni88
    Business rule executing long
    Summary Business rule executing longContent Hi, One of the BR running long time more than 6hrs than usual time (Usually 2 hrs). When we check the essbase log we could no…
    Received Response
    Mmavs Seeni88 20 views 3 comments Most recent by Srinath Raman
  • Shoaibmdshaik
    EPMA Planning Import profile
    Summary EPMA Planning Import profileContent Hi All, Currently I am working on one project. So let me give you some details about the project so you all can help We have …
    Received Response
    Shoaibmdshaik 14 views 2 comments Most recent by Dayalan Punniyamoorthy
  • Sabarirajan S S
    Smart view doesn't throw a warning with unknown members
    Summary Smart view doesn't throw a warning with unknown membersContent Hi all... I`m using Smart View 11.1.1.2 It doesn't throw a warning with unknown members; cube chan…
    Received Response
    Sabarirajan S S 19 views 9 comments Most recent by Sabarirajan S S
  • pr144
    Report Script output dir
    Summary Report Script output dirContent I execute the following successfully, export database 'Master'.'BUDGET' using server report_file 'x_Bud' to data_file '\\\\hyperi…
    Received Response
    pr144 8 views 6 comments Most recent by pr144
  • Rakshith Ss
    Issue when connecting and retrieving data from a password protected report on SV version 11.1.2.5.7
    Summary Issue when connecting and retrieving data from a password protected report on SV version 11.1.2.5.700Content Smart view issue. Background- we have current profuc…
    Received Response
    Rakshith Ss 18 views 2 comments Most recent by Rakshith Ss
  • Thierry Bacchetta
    EAS Calc Scripts and DLR Dispearing
    Summary EAS Calc Scripts and DLR DispearingContent Hi All, We had a pretty weird Issue recently: Scripts and Rules Nodes is EAS have dispeared with all the containing sc…
    Received Response
    Thierry Bacchetta 7 views 3 comments Most recent by John Goodwin-95056