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

Essbase

Discussion List

  • Sunil Ggate
    Essbase Version
    Summary Essbase VersionContent Hi All, I want to know the exact version of Essbase and the latest patch installed . Can someone please help me here . -Many Thanks
    Received Response
    Sunil Ggate 21 views 4 comments Most recent by TimG
  • Teddd
    Formula Help
    Summary Formula HelpContent Hi All, Need some help with a member formula which calculates the 3 month average of another account. For Eg:AVG_Account1 = 3 Month Average o…
    Received Response
    Teddd 30 views 5 comments Most recent by Cord234
  • Sasank Mekala
    Smart View office error EPMHFM 69547
    Summary Smart View office error EPMHFM 69547Content The error message says invalid cell, member ‘ACTUAL’ is not in proper place EPMHFM 69547
    Received Response
    Sasank Mekala 608 views 15 comments Most recent by SureshM-Oracle
  • Robert Angel-58279
    Smart View Documentation
    Summary Smart View DocumentationContent Sorry if this is a total newbie question, but I am trying to find the documentation for Smart View - anyone point me at a URL ple…
    Received Response
    Robert Angel-58279 9 views 4 comments Most recent by Robert Angel
  • Pchauhan1168
    Need to find the count of substitution variable in various calc script and business rule ?
    Summary Need to find the count of substitution variable in various calc script and business rule ?Content Hello Everyone, Hope, all are doing well. I have a requirement …
    Received Response
    Pchauhan1168 17 views 1 comment Most recent by Dan Gagnon
  • Vksiri123
    Agg issue in Hybrid cube
    Summary Agg issue in Hybrid cubeContent Hi All, I had a Hybrid cube with 8 dims 2 dense and 6 Sparse, data is not aggregating for Sparse dimensions in Hybrid cube ... I …
    Received Response
    Vksiri123 14 views 5 comments Most recent by TimG
  • Teddd
    Essbase Usage Tracking
    Summary Essbase Usage TrackingContent Hi All, How does everyone track usage activity within essbase? We are looking for some sort of an automated option to track users w…
    Received Response
    Teddd 21 views 3 comments Most recent by John Goodwin-95056
  • Durgaramv
    Failed to deploy Essbase cube
    Summary Failed to deploy Essbase cubeContent Hi, I have the below error and our cube deployment is done through Essbase studio. Product_Division_State is an attribute di…
    Received Response
    Durgaramv 30 views 10 comments Most recent by Durgaramv
  • Nibandha
    Data entry through script
    Summary Data entry through scriptContent Hi I wanted to enter some codes or data via script so that FY17->BUDGET->FINAL would be "5", FY18 would be "6", FY19 would be "7…
    Received Response
    Nibandha 13 views 1 comment Most recent by ManojPavan Ch-75585
  • Dev Devil
    RESTRUCTUREHEADS not working as expected during defragmentation
    Summary RESTRUCTUREHEADS not working as expected during defragmentationContent Hi All, We have a planning cube, and we carry out the defragmentation activity by adding a…
    Received Response
    Dev Devil 11 views 15 comments Most recent by John Goodwin-95056
  • User_GKYRR
    Error executing formula for (line 16): attempt to cross a null member in function
    Summary Error executing formula for [LCL] (line 16): attempt to cross a null member in function [@X]Content Hi Gurus, I am using Essbase 11.1.2.4 version and I was getti…
    Received Response
    User_GKYRR 9 views 3 comments Most recent by Skavuri400
  • Teddd
    Log File for MDXDatacopy on Linux
    Summary Log File for MDXDatacopy on LinuxContent Hi All, Am scripting the MDXData copy in the following manner, //ESS_LOCALE English_UnitedStates.Latin1@Binary RUNJAVA c…
    Received Response
    Teddd 15 views 3 comments Most recent by Teddd
  • Teresa Modesta
    Smart View Error
    Summary Smart View ErrorContent Hi, trying to add a ad-hoc analysis using Hyperion source, but keep getting this weird no valid blocks error??
    Received Response
    Teresa Modesta 18 views 2 comments Most recent by Robert Angel
  • Dev Devil
    Triggering maxl through a batch script kept on different server
    Summary Triggering maxl through a batch script kept on different serverContent Hi All, We have a maxl to export zero level data from one of our planning cubes. This maxl…
    Received Response
    Dev Devil 20 views 3 comments Most recent by John Goodwin-95056
  • Jenny Tan
    Data validation format in Cells not used
    Summary Data validation format in Cells not usedContent Hi, I am using excel 2106 and smart view version 710. I notice that when I built essbase ad hoc report using smar…
    Received Response
    Jenny Tan 24 views 3 comments Most recent by Dan Gagnon
  • Karl Nicholas Lisondra
    Excel formatting does not keep the format when missing rows are suppressed in Adhoc Connection.
    Summary Excel formatting does not keep the format when missing rows are suppressed in Adhoc Connection.Content Hi folks, I am in adhoc connection in SmartView and using …
    Received Response
    Karl Nicholas Lisondra 12 views 13 comments Most recent by Skavuri400
  • Sri Mannava1234
    Access to Explore Financial Reporting Folders
    Summary Access to Explore Financial Reporting FoldersContent Hello Team, I duplicated access to one of the new user exactly same as our old user. Somehow new user can't …
    Received Response
    Sri Mannava1234 23 views 2 comments Most recent by Sri Mannava1234
  • King Raman
    Smartview Compactability.
    Summary Smartview Compactability.Content Hi All, Can you please help me on smartview compactibilty. i have a smart view version 11.1.2.5.700, i would like to know whethe…
    Received Response
    King Raman 24 views 5 comments Most recent by King Raman
  • Alvaro Duqueestrada
    ASO Member Formula SV Issue
    Summary ASO Member Formula SV IssueContent Dear Essbase community gurus, We have an application where we are loading beginning balance in "BegBalance" period and then lo…
    Received Response
    Alvaro Duqueestrada 30 views 11 comments Most recent by user111989
  • user12062115
    Hyperion Smart view read only access
    Summary Hyperion Smart view read only accessContent Is there a provision in Hyperion EPMA to allow users to READ only access on smart view essbase data . Requirement wou…
    Received Response
    user12062115 40 views 2 comments Most recent by Dan Gagnon
  • Sunil Ggate
    Smartview Issue
    Summary Smartview IssueContent Hi , I am facing some issue in Smartview. First I have connected to one database and pulled data. Then I disconnect that and reconnect to …
    Received Response
    Sunil Ggate 14 views 5 comments Most recent by user111989
  • Dzhao -93207
    alternative QTD, YTD
    Summary alternative QTD, YTDContent Hi There, I have BSO cube with typical Years, and Period (Quarter- Month), Accounts and Department dimensions, however one company we…
    Received Response
    Dzhao -93207 44 views 12 comments Most recent by Dzhao -93207
  • Dev Devil
    Automating LRO creation through smartview
    Summary Automating LRO creation through smartviewContent Hi All, We have a planning application(epma) where-in a set of users are still using smartview with essbase conn…
    Received Response
    Dev Devil 22 views 13 comments Most recent by Dev Devil
  • Pchauhan1168
    Is the fixing of dimension logically correct?
    Summary Is the fixing of dimension logically correct?Content Hi All, I am just wondering whether below fixing of dimension member within FIX statment is logically correc…
    Received Response
    Pchauhan1168 23 views 2 comments Most recent by user111989
  • Phulsebosch
    Who has more information about the function @XDIMSLN ?
    Summary Who has more information about the function @XDIMSLN ?Content Hello all, I was scrolling through some calculation scripts made for sample application of Planning…
    Received Response
    Phulsebosch 51 views 6 comments Most recent by Peter Nitschke-80364
  • User_6GP2D
    Verify/Check Syntax of Calc Script via MaxL?
    Summary Verify/Check Syntax of Calc Script via MaxL?Content Hi, Is there a way to verify/check the syntax of a calculation script via MaxL or any other scripting? Thanks.
    Received Response
    User_6GP2D 11 views 6 comments Most recent by John Goodwin-95056
  • Vijaya Kumar Kasireddy
    How to delete the Attribute member
    Summary How to delete the Attribute memberContent Hi All, The below screen shot it shows the attribute TestATt , how to delete the TestATt attribute value? by mistake th…
    Received Response
    Vijaya Kumar Kasireddy 19 views 2 comments Most recent by John Goodwin-95056
  • Pchauhan1168
    Need your advice on data export optimisation from essbase to relational table
    Summary Need your advice on data export optimisation from essbase to relational tableContent Hi Team, I have a scenario where i am exporting level 0 data from essbase to…
    Received Response
    Pchauhan1168 20 views 3 comments Most recent by Pchauhan1168
  • Vksiri123
    Export Partitions
    Summary Export PartitionsContent Hi All, I have 2 partition new cubes in Test env and I want to move them to QA ..I tried to export complete cube using LCM from Test to …
    Received Response
    Vksiri123 21 views 11 comments Most recent by user9928941
  • deeeee
    TREND Script
    Summary TREND ScriptContent Hello, I am trying to create a pretty simple trending script in Essbase using some statistical data from a public source. The gist is I want …
    Accepted answer
    deeeee 26 views 3 comments Most recent by Phulsebosch