-
Form 4562 Summary Report
Description Provide an aggregated summary of data relevant from the following tax reports: Form 4562 and 4797 for both 1245 and 1250 property. This would not only be useful, but it is also essential in tax reporting for filing purposes. The report as it is doesn't help much when it comes to preparing any of these tax…
-
Add option on number formatting percentage tab to not multiply metric by 100
When adding out of the box metrics that have to do with percentage such as line percentage from Labor Distribution subject area, if I add the percentage number format it takes the value from 100 to 10,000% for example. This is not the correct data I'd like displayed. If I want to use the number formatting, I have to create…
-
FDI BI Publisher Connection Manager
Please create a better interface for entering multiple reports in the List of Reports. One line with commas for separators is difficult to read and wrought with the possibility for errors. It would be nice if you didn't have to put the password in every time a change was made. It would also be nice to be able to resize the…
-
Aggregation by clause in not working in FAW Semantic Model Extension
Hi All, The Aggregation by clause in not working in FAW Semantic Model Extension and we need this function/feature to calculate multiple matrixes in the FAW. Thanks & Regards, Vivek Gautam
-
Flexibility in filtering inbound records for data augmentation tables
Over the period, the Data Aug tables grow into millions (100s of millions) as we are not able to control/filter the inbound records. Thus, the custom ETL that is going to be built will get slower and slower day by day. As a result, we require the ability to have the following: Ability to purge records from data aug tables;…
-
Personalisation on Filter Bar dimensions
The personalization of dashboard filters from the January OAC update works on filters inside the canvas (i.e. dashboard filters or interactive visualizations). However, in our dashboard, we have preferred using the filter bar to place the filters for our users so that we can pin them across the canvasses. Can it be…
-
Request a BICC PVO for fusion table inv_transactions_interface
Used to load to an external data store, we need this for ease of extraction from Fusion for operational reporting and analysis.
-
How to present % sign in Analysis?
How can we present the % sign in Analysis? We could not find the % symbol in FAW. This is needed for our reports as some of the reports show comparative analysis and require the % sign in column.
-
Description not available when selecting hierarchy, only code is available
Is it possible for the user to see the account description in addition to the account code? Presently when we select hierarchy it only shows the code and there is no opting for selecting description. This is the result we get. These are only the codes and there is no description. Furthermore, can the user only see the…
-
Searching all the levels for any dimension
Is there a way to say search all levels? For example if we want to search any account code which appears in multiple levels or hierarchies how can we achieve that. For instance in SmartView, there is a search option where the user can search any account and it shows all possible values where the account is available.…
-
Getting finer details of pipelines run times
Whenever events like pipeline data load, data warehouse reset are executed, the runtimes are not available to review at the pipeline level. It is only at a very high level. The run time at the pipeline level will allow us to understand the time taken and if more frequent run can be scheduled for more real time data.
-
Need ability to add Logical Level Filters in Semantic Model layer in FAW
Currently we don't have any ability to add Logical Level filters on LTS to filter out rows in Facts/Dimensions in Online semantic Modelling.
-
Need capability to Add Commentary in Visualisation Based on Data Trends.
It will be Good to Add Notes/Comments similar to EPM Narrative Reporting for specific DV with set of parameter selected. This feature of adding comments is available in EPM but will be nice to have in FDI/FAW. Current Note Feature on the DV is static and is not dependent on Params/filter selected. Either it has to be…
-
Include Item Expense Account as the GL Account Combination in Financials - AP Invoices subject area
Right now, when we select the "GL Account Combination" field from Financials - AP Invoices subject area, the natural account segment value is a liability account. We would expect this subject area to have the item expense account from the invoice line as the default account combination, as that is what users see in the…
-
FAW: Missed information about PO, Receipt number, Supplier, Item number in CAA Subject Area.
Source - SR 3-33153188501: Missed information about PO, Receipt number, Supplier, Item number in CAA and GL Account Analysis Customer - Ctb Inc Request Description - Customer looking for PO, Receipt number, Supplier, Item number in CAA and GL Account Analysis subject areas. Currently we don't have any provision to join the…
-
DV to include tooltips when exporting to CSV
The idea is - if the workbook will render - it should also export to csv - including tooltip columns as part of the query when exporting to csv We had an issue where a workbook would render just fine and would export to any format except csv. We came to find that this was due to blending subject areas - one subject the…
-
FDR (Frequent Data refresh) process FDR table by batch rather than individually
In FAW FDR, if we have multiple tables (say 5) in the FDR list, the scheduler will need to wait for all 5 tables to be finished before running the next schedule. So if the 5 tables took more than 1 hour, the next schedule will not run and only run after 5 tables are finished Say we have hourly schedule from 8AM. 4 tables…
-
Ability to show update history of a particular report
Is it possible to Build a report to show details on user changes made to a particular report with the following column: Report Name Description User name Date Time Object that were changed Last change date
-
EDM to FAW support for extract with with comma in the values of columns
We have noticed that FAW data augmentation for EDM does not support EDM extract with comma in the actual values. FAW Data augmentation also does not support if the CSV file has double quotes as quote qualifier. Would be good to have support for above options as loading CSV extract with comma in the values and quote…
-
FAW Security Roles for self-service analytics
Our organization would like to enable fully self-service analytics (data augmentation, semantic development, dashboard development, data validation). The functional administrator role as currently defined is more of an administrative role - having nearly complete functional control over the instance apart from security.…
-
Importing All Files within a Given Directory
As a data engineer, I should be able to create a connection to a folder in File Explorer, that contains many spreadsheets that have the same set of columns and are destined for the same dataset. The user should be able to nominate the disposition of the processed file: Delete, Move to another folder, or none.
-
Need PVO for fusion table CMR_RCV_DISTRIBUTIONS
This is a base table that we believe should exist as a table extract PVO. Current method to extract using BIP is limited given the number of transactions that requires partitioning of data and is not sustainable if a full extraction is required.
-
Audit for saved customization report
Problem: The saved customization reports in OTBI are being deleted for some users. It occurs once a year. Requirement: To have an audit or logs for all the transactions done on the customization report to identify what were the process/transactions done why the saved customization was deleted Add a column on the existing…
-
Drill to lower level of GL Segment Hierarchy
We want to have the drill to a lower level option in a GL Segment Hierarchy (e.g. Cost Center Hierarchy or Natural Account Hierarchy). Similar as the current function in FDI for other Hierarchies like Project Organization Hierarchy. When right-clicking on Level 1 the option "Drill to Project Organization Level 2" appears…
-
In-App Messaing / Commenting Functionality
any potential or interest in having in-app messaging / commenting features inside of NSAW (FAW), so users can collaborate and message each other inside the app?
-
New attribute needed for Job Code offered in Talent Acquisition SA - Job Offer Folder
We need to add a new attribute to FAW for Job Code offered which could be different from Job Code on requisition. We do have the job code tied to the job requisition (Recruiting - Recruiting Real Time > Job Requisition > Job > Job Code). As far as the relationship of the job code to the job req, it should be tied to the…
-
Is there a way to extract all BI Report Names in the exists custom folder from BI catalog in Fusion
There are tons of reports that are built on our POD by various teams. We are looking for a extract of all the reports name that exists in the custom folder. We have explored the standard reports like BI Auditing etc., these seeded reports are not giving the information that is greater than 6 months. We have also checked…
-
Ability to export the DVs Details
In Analytics world, using the Catalog Manager, we were able to extract Dashnoard, Reports within Dashboards, Subject Areas, Prompts, Filters, Tables, Columns etc BUT in DV world there doesn't seem to be an option currently. Could you please provide us the ability to export such details of DVs which includes all Workspaces,…
-
Use of CSS for customization
Hi All, Can we use CSS in FAW or any idea how to implement it here. Regards, Ravi
-
Add ability to change default settings on filters for Decks
The Filters which are applied to each Deck always default to the first value in the list of values available. It would be beneficial to be able to control the default values for these filters. A good example is the Ledger Filter for all my decks defaults to our CAD currency ledger because that is the first value in the…
