Essbase
Discussion List
-
PJTD in Smart ViewSummary Select PJTD as AMOUNT TYPEContent Hello All New to Oracle Fusion and the Smart View world. Quick question is it possible to select PJTD (Project to date) as the …
-
Matching Level zero accounts with attribute tags in Replicated partitionSummary Matching Level zero accounts with attribute tags in Replicated partitionContent Can you match level zero accounts with a specified attribute tag in a replicated …
-
OAC Essbase trial user & groups provisioningSummary How to create users & groupsContent Dears, I have been working on a POC on OAC Essbase. Now I need to create some users and groups however can't find any create …
-
Rolling 3 month sumContent Hi There, We have dimensions, Years, Periods (time dimension) with Quarter - Month, Account, etc. I would like to create rolling 3 month sum, for example, curren…
-
Export On-Premises Cubes to Import to the CloudSummary We are not able to export On-Premises Cubes to Import to the CloudContent Hi We have an on-premise Essbase cube(Essbase Version 11.1.2.2.100), that need to be mi…
-
SmartView Backwards Compatible with older version of ExcelSummary Is SmartView 11.1.2.5 900 compatible with older version of ExcelContent Hello Essbase World, I have a question about SmartView and Excel when connecting to Essba…
-
Unexpected end of ZLIB input streamSummary Tried to import lcm backup zip file to create a new application,But when i tried the LCM Import in the Essbase cloud, it shows up the error "Unexpected end of ZL…
-
FRS - member descriptionsSummary Descriptions are blank in FRS DimensionsContent Can anyone help explain why the Member Alias (Default) in FRS merges the Value and the Description? And how to ge…
-
OAC Essbase Google Sheets add-onSummary You can now access your OAC data from Google Sheets exactly like you do in Excel using Smart View.Content We're happy to announce the availability of our "OAC Es…
-
Disable "Duplicate member names allowed" option vía scriptingSummary We need some help finding a way to disable the "Duplicate member names allowed" option with a scriptContent Hi everyone, We have a Planning app deployed with EPM…
-
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…
-
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 -…
-
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…
-
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…
-
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 …
-
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…
-
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…
-
Smart View version 800 and 710Summary Adaptation Issues?Content Hi, most of our users are using smart view version 710 and our report layouts (both standard smart view and function reports) are also …
-
Unable to load data using Rule fileContent I am new to Essbase. In EAS Console, In my outline, I have only one parent object called Products and two children namely Honda and Toyota. I myself have created…
-
Require help to build data file for the outlineContent We have attached the outline of one cube. We are having to design a rules file and hence our own data file. Can you please help us design data file for the outli…