Forms
Discussion List
-
How do I add a formula row for each member of a dimension in a Form 2.0?Hello everyone. In a form 2.0, I have the "period" dimension as a column and two other dimensions as rows. Is it possible to use a row formula to get the total sum of th… -
Optimize User Variable Member SelectorFor the past few months we have noticed it takes longer to load the Entity User Variable member selector. It's currently taking ~20 seconds to load before you can make y… -
In the form page section, is it possible to select more than one member of a dimension at a time?Hello everyone. I have a form, and one of the filters is for the customer dimension. The user needs to be able to select multiple customers at once and have the informat…
-
Bug or not? About member on form gets removed.Summary: Content (please ensure you mask any confidential information): Hi, As people all knows that if dimension members are explicitly used on forms, you won't be able… -
Security for Action Menus?Are there any permissions options for action menus? I'm having an issue because I'm developing a set of forms / dashboards shared by both the Budget Office and regular u…
-
How to print attachment file in cell commentHello everyone, I have attached the Excel file to a cell : My question here is: How can I print all the attachments in all the cells at one time? Is there any feature or… -
file attachment limitation size in commentHello everyone, I want to ask : What is the attachment size limit in the EPBCS Data Form? Is there any Official document refer to this? Thanks and have a nice day.
-
Sort values in form using Groovy, possible?Hello! Does anyone have experience with sorting values in a Form? For example displaying "top 10 values" or "least profitable services" or similar? My search so far have… -
How can I know where the form is open in Excel?Hello everyone, I am opening the form in SmartView on a web browser : However, when launching the .sclnk file, sometimes it opens in workbook A, sometimes it opens in wo…
-
Smart List Labels Not Updating After Alias ChangeSummary: I have a Smart List that's derived from members. When I update the member alias in the dimension editor, the Smart List label doesn’t update automatically. What…
-
(PLEASE IGNORE THIS) Invalid Dimension Name in Asymmetric rowsSummary: Content (please ensure you mask any confidential information): Hi, When we do the Clone from TEST to PROD (in same version), everything is fine except for sever…
-
Can Form Spreadsheet Exports be Formatted?Summary: Is there any way to apply formatting to form spreadsheet exports (the Excel file that is generated when a user clicks on Actions→Spreadsheet Export)? (This woul… -
Dashboard 2.0 Not Displaying Full Form Data Like Dashboard 1.0Summary: We’ve noticed a significant usability issue after transitioning to Dashboard 2.0. Users are unable to view the complete data sets for forms positioned in the mi…
-
Pull in Entity Currency on FormSummary: Content (please ensure you mask any confidential information): Is it possible to have the currency on a form pull in based on the Entity? For example, if Co05 i… -
Why is the dimension mapped in the cube, but not available to be used in forms?Summary: The intercompany (ICP) dimension has 13 members in total. In FS cube I can see all 13 members mapped in the cube. In BankRPT cube, even though I can see all 13 … -
How to use retained earnings account in a balance sheet account structure?Summary: The IS Retained Earnings account we use has a formula (@SUMRANGE ("MACC_99999",Jan:@CURRMBR (Period))) in FS cube. When I try to add this account to the hierarc…
-
Update Valid Intersections Rules via GroovySummary I want to create valid intersections rules or conditions via groovy while creating a new memberContent Hey all, I have a situation where the client has several v…
-
Why doesn't leaf level data in financial forms, roll up to top level dimensions?Summary: We have data uploaded for plan and actuals in financials at leaf level. When we select the specific POV we can see the data uploaded, but when we filter for top…
-
"Business Rule completed successfully" pop up not showing in SmartViewSummary: Hello , We have a form that has a business rule and smart push attached to it . Upon saving the form , the rule has to run followed by the smart push . In web ,…
-
Access type Read allows a Power User to edit a form or Write does not allow a User to edit a Form.Hello EPM Expert, We are facing a situation (in EPBCS simple forms) that Access type Read allows a Power User to edit a form and Access type Write does not allow a User …
-
Parent First Functions on FormsSummary: Content (please ensure you mask any confidential information): Hi, I know this is something asked by many people. Just noticed that this feature was released in…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
Forms 2.0: Same dimension in multiple columns: start in one column expanded, in others collapsed.Summary: Form with FC/ACT/BUD in columns, each scenario with 12 periods (IDescendants(Periods_Total). I want FC scenario to start with expanded periods, the other should…
-
Cell level security not working at Parent/Aggregated level in Workforce cubeWe’ve implemented cell-level security on our Workforce cube to restrict access to salary details by applying a “Read access – Deny Read” policy at Level 0 of “Total Empl…
-
BegBalance is editable on a closed year?Summary: BegBalance is editable on a form for a year that is closed to a scenario Content (please ensure you mask any confidential information): We have a form with BegB…
-
Forms 2.0 Column Level Number Formatting (Currency vs. Plain Number) in same layoutSummary: Forms 2.0 Column Level Number Formatting (Currency vs. Plain Number) in same form and layout Content (please ensure you mask any confidential information): Hi a…
-
Business Rules RTP behavior between Forms 1.0 and 2.0.Summary: Hi Experts, I have a Business Rule with RTPs that include both numeric values and Smart List selections. I have set Allow #Missing at both the variable and rule…
-
Existing Employee OOTB Form performs poorly if Custom Dimension (Cost Centre) is pulled into rows.Summary: Existing Employee OOTB Form performs poorly if Custom Dimension (Cost Centre) is pulled into rows, even if the number of rows are less than 100. Anyone experien…
-
Issues (bugs?) with new Forms Format/Validation Rules feature, PBCSI have been trying to use the new Format/Validation Rules feature in Forms (in QA) but there appears to be a number of bugs\issues with it. Has anyone else been using it… -
How to hide #noaccess and display data for users in EPBCS formsSummary: In EPBCS we are using Cell level security to restrict access for certain intersections based on security groups. However, we noticed a strange behavior: When us…