SmartView
Discussion List
-
Is there functionality in EPM to create a relative timespan?Summary: Looking for a way to have reports, automations and various other processes run based on a relative timespan. The goal of this would be to not require updating s… -
Alias tables in SmartviewSummary: How are these created / where are they coming from? Can additional Alias Tables be created? Content (required): In SmartView (Essbase) when switching between Al…Delaney Wastler 51 views 4 comments 0 points Most recent by Bala Murali SV General Ledger & Intercompany -
Prompt to display user name after a rule is ranHi There, I am trying to create a rule which will display the scenario, version, date and user name which the rule is ran for. The section of the rule that does this: FI…
-
Disable Login screen in smartview using macroSummary: Dear All, We are looking out for option to disable login UI while creating the smartview refresh sheet. We are using macro and using HypUIConnect function to lo… -
Remove ASCII characters from text data in Data Management (EPBCS)We are getting "XML Load Error: Invalid Unicode Character" error while refreshing Text data in SmartView for ASO cube as there are ASCII symbols in text data which got l… -
Export and Import to a file Rules, Rule Set and Model's in EPCMSummary: The objective is to automate the creation, alteration and deletion of Models, Rule Set's, and Rules (usual artifact to configure and allocation rule and grup of…Michel_MB_PwC_ADV 101 views 2 comments 1 point Most recent by Michel_MB_PwC_ADV Profitability and Cost Management -
ASO Cube - Drill Down Vs Refresh of BottomSummary: I'm facing a weird use case with our ASO reporting Cube. Our Reporting Cube is very sparse and we have 2 big dimensions : 1 emplyee dimension (around 80k member…
-
SmartView Crashes or hangs indefinitely(EPBCS applications).We are using MS Office 365 and SmartView version 22.200 and at times, the excel hangs indefinitely(mostly while refreshing the forms) and then, there is no option to clo…
-
Multiple currencies are visible in SmartviewSummary: On test instance, we see the currencies outside of USD and STAT are disabled under Manage Currencies and are also not listed in Manage Reporting Currencies and …
-
Drill Through Does not return any data when executingSummary: When i Try to drill, the landing pange open and i recieve the follow message: Drill query does not return any data. Data was not loaded to this intersection usi…
-
Smartview - Lock Member SelectionsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): Apologies if … -
Tree Version Start and End DateSummary: Purpose of Tree Version Start and End Date Content (please ensure you mask any confidential information): Can someone please help me to understand the purpose/o…ramesh.sivapalan 71 views 4 comments 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
See Report Books in SmartViewSummary: Content (please ensure you mask any confidential information): I have a number of FR Reports books that I have in PBCS. However, I am unable to see them when I … -
How to connect to Oracle Cloud ERP in Smartview using HS Functions?Hi, We are trying to connect to Essbase cube of Oracle Cloud ERP via Smartview. Specifically, we are trying to use HS functions (Example: HSGet, HSset). But when we try …Guntuka VenkataKrishna 31 views 2 comments 0 points Most recent by Guntuka VenkataKrishna General Ledger & Intercompany
-
SmartView for non office 365Summary: The customer has a standalone, non-365 version of Microsoft Office suite Content (please ensure you mask any confidential information): Do we have SmartView set…
-
Remove User Permission to Save Forms/Grid into LibrarySummary: Content (please ensure you mask any confidential information): I have users that have been saving ad hoc grids as forms in the library. However, I cannot find a…
-
Changing Accounting Calendar from Fiscal to Calendar Year in Oracle FusionSummary I am trying to change our accounting calendar from Calendar Year to a Fiscal Year. Has anyone been able to do this and are there any downstream impacts?Content W… -
How do you install a previous version of Smart ViewSummary: Content (please ensure you mask any confidential information): I have one user whose excel crashes whenever they try to refresh a workforce employee roster form…
-
Unable to connect to SmartView with same credentials as web accessSummary: I could previously connect to Smart View via both shared and private connection, but after the epm login page changed, I am no longer able to connect to Smart V…
-
PBCS Offline formsHey, I'm unable to connect the Offline forms through SmartView More option. For this issue, I had reviewed Oracle Documentation, there I have found this Note: Offline fu…
-
Excel formulas in Strategic Modeling Freestyle reports randomly not sticking in the modelsWe are creating freestyle reports in Strategic Modeling containing a few basic Excel formulas for subtotals or simple calculations. It works most of the time but in some…
-
Smartview query: There are 2 database connections in smartview and both are visible.Summary:Smartview query: There are 2 database connections in smartview and both are visible when we try to connect to Databsase connection. We want to hide one which is …
-
FRS & Smartview Report helpSummary: In the FRS & Smart View report we have ''AccountingPeriod'' dimension where we can see GL Periods and able to select. But our requirement is to select date rang…
-
Retrieve Parent of member in SmartView / HSGetHello Experts, Is there any way to retrieve the parent of a member in Excel? I have a file that uses HSGet (it was a necessary evil to achieve the layout i needed), and …
-
Smartview handled unknown exception thrown by Microsoft office.Summary: I received a message every time I open Excel. The message is: "Smartview handled unknown exception thrown by Microsoft office". Has anyone encountered this befo…
-
When I use zoom it on smartview, can the hierarchy open downwards instead of upwards?Summary: When I open the account hierarchy using zoom it, the parent accounts are placed below the child accounts. Is it possible to change this? Parents are ranked firs…
-
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 51 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Changing Smartview settings via scriptSummary: I had the issue - SR 3-34040867641 : FR - Report doesn't show the arrow - similar to "+" - indicating that the member has children. - and the solution is to cha…
-
Copy Entity data from one period to anotherSummary: It is required to copy Consolidated data for ultimate parent company to another Standalone entity to support Tax computation at Group level. Content (please ens…