Essbase
Discussion List
-
ASO MDX Data copySummary ASO MDX data copy script is taking hrsContent Hi All, I have an MDX script which will copy data from one member to other member it is taking 3 hours to complete … -
extraction of parent and child together in report scriptSummary extraction of parent and child together in report scriptContent Hi , How to extract data along with both and child in report script or any other means with scrip…
-
Formula to retrieve the top ancestor for an entity memberSummary Trying to run a report that identifies the parent or top ancestor for all entity membersContent Trying to run a report that identifies the parent or top ancestor…
-
Method to find intersection with actual data in Essbase with SmartViewSummary I'm trying to find a simple way of targeting an intersection where there is non-missing, non-zero data.Content Hello Oracle Essbase World, I have a fairly simple…
-
Working Day MetricSummary Analyzing various statistics against working daysContent We recently implemented two OAC Essbase cubes, 1 ASO and 1 BSO. Within the BSO cube, our dense dimension…
-
Planning Analyze not workingSummary Planning Analyze not working - " Ad hoc grid can not be opened as there are no valid rows of data"Content Hello, After the May update we noticed an odd behavior … -
Data Copy in OAC Essbase ASO CubeContent G'day,I am wondering if anyone has had success running a data copy calc on an OAC-Essbase ASO cube using MaxL. The error I keep running into is ERROR - 1241109 -… -
Schedule JobSummary We are just starting playing with OAC EssbaseContent We are just starting playing with OAC Essbase, is there any scheduling capability for executing data refresh…
-
Capture Data in Unlocked Cell in Protected Workbook Smart View ErrorSummary Capture Data in Unlocked Cell in Protected Workbook Smart View ErrorContent Hi I've created an ad-hoc grid to enable users to load data into an OAC Essbase cube.…
-
Possible to retrieve a numeric value and refer it it as a member name?Summary Investigating the possiblity of storing and retrieving a numeric value, and having a calc scrpt pull the number and then reference it as a member name.Content Th…
-
Report ScriptContent Hi All, Do we have any command to convert the report script extract negative number . I am getting it as (54) but i want it as -54 . I tried to look for the comm…
-
Load backup .txt data into Essbase CloudContent Hi There, We are in the process testing on essbase cloud version, I am able to migrate application and cubes into OAC using utility provided. However is there an…
-
Submit Text Label (Typed Measures) with HSSet Smart View FunctionSummary Submit Text Label (Typed Measures) with HSSet Smart View FunctionContent Hi Can you use an HSSet Smart View Function to submit a text label (Typed Measures)? If …
-
How to give permission to execute calculation command in Essbase cloudContent We tried to execute the sequence of scripts using the execute calculation command but it throws an error. Can someone let us know how to grant access to execute …
-
ASO copy then load additive issueContent ASO cube that is copying data into a current month then loading additively on top of this data to create a total. The problem is the load file might have a minim…
-
Having issues enabling DTS for Y-T-DSummary Having issues enabling DTS for Y-T-DContent Hi Having issues enabling DTS for Y-T-D. The value gets updated on the working sheet but fails to be updated on cube …
-
Managing Text List (aka SmartList) in OAC Essbase UI is Yet to Be ImplementedSummary In my version of OAC Essbase Cloud UI (version: 12.2.1.1.110) support for managing Text List is only supported in Cube DesignerContent To begin with, the OAC Ess…
-
Encrypt PasswordSummary Encrypt PasswordContent Hi All, In Cloud System how to set up the Encrypt Password ? How to get the Encrypt user name and Password?
-
Member Formula in Essbase Went #MISSING After Doing DB Refresh from Hyperion PlanningSummary Member Formula in Essbase Went #MISSING After Doing DB Refresh from Hyperion PlanningContent Hi Gurus I found an issue where formula in Essbase outline went #MIS…
-
How to have Date Type in Measures in Essbase Cloud?Summary How to have Date Type in Measures in Essbase Cloud?Content Hi, I have a requirement where I need to have Start and End dates in Measures dimension in Essbase Clo…
-
Does Essbase replace numbers with #0 or #Missing during data loadsSummary Question about data update while performing a Level -0 data restoreContent We have the need to restore our Level 0 data from a particular day's ( 4 days prior) b…
-
How can i copy the .otl file in ASO cube to other cubeSummary I need to copy the .otl from shell ASO to Stg ASO application. How can i access the .otl file.Content I have a shell application, I need to copy the .otl file (A…
-
How can i build the dimensions using the .xml file in OAC EssbaseSummary Hi, i have .xml file which contains the dimensions and members (which was exported from other ASO cube). How can i import the dimesnions(,.xml file) into the new…
-
ASO Time Balance QTD YTDContent Hello, Using Version 11.1.2.3, and some of the Account members tagged as TB Last and rest are None. Now we need to have the QTD and YTD functionality without add…
-
HypRetrieveRange() return error 4 when executed in loopSummary HypRetrieveRange() return error 4 when executed in loopContent Hi everyone, I have a small macro where I use the function HypRetrieveRange() on a selected range …
-
Execute Hyperion Report via VBASummary How to run a predefined report via VBAContent Good Morning, I just started learning about Smartview automation via VBA. I got the developer guide, and when it co…
-
Oracle Autonomous Analytics Cloud ServiceSummary Regarding StorageContent Hi, In OAAC with Essbase edition,whether there is any default storage associated with the instance while provisioning?If so how much?If …
-
Has anyone tried applying OAC patch 18.3.3-122?Summary OAC patch 18.3.3-122 failsContent Heads up to anyone planning to apply the latest OAC patch 18.3.3-122. I tried applying the patch today and it failed. Has anyon… -
User authentification needed.Sign onSummary User authentification needed.Sign onContent Hello, We receive 'User authentication needed' error in Smart View every time we refresh the data. Has anyone faced t…
-
Target Application and Import Format details in FDMEEContent We have sample outline and data file for a cube which we have been able to load through a Rules file. Now we are trying to load the data through FDMEE. We requir…