Schedule Call
Schedule Call

Blog

NetSuite Smart View Mac Installation image 1
(0) Comments

NetSuite Smart View Mac Installation

NetSuite Smart View Mac Installation Step 1 – Creating “Wef” Folder In order to install SmartView on Mac, we first need to create a folder called “wef” This is where we will save the manifest file. First, we need to determine our home user. To do this, open the terminaland write-out the following command: whoami […]
Read more
(0) Comments

OneStream Formatting When Dividing by 0

OneStream Formatting When Dividing by 0 While working in OneStream, users may experience formatting issues when trying to get a ratio by dividing a specific POV by another POV. A formatting issue happens when the denominator is 0, and since you can’t divide by 0, formatting the equation improperly will result in a formatting issue […]
Read more
Easily deliver reporting packages to your Users Part 2 image 1
(0) Comments

Easily deliver reporting packages to your Users Part 2

Easily deliver reporting packages to your Users Part 2 As noted in the previous blog, OneStream books are an excellent way to deliver reporting packages to your users. Also, in our previous blog, we looked at the basics of creating a book, including organizing books into folders, and created a book that ran several reports […]
Read more
Featured image for The Importance of a Source Dimension in Oracle PBCS
(0) Comments

The Importance of a Source Dimension in Oracle PBCS

The Importance of a Source Dimension in Oracle PBCS Dimensions are the components that label, store, and arrange data. Each dimension contains a hierarchy of related members grouped in a parent/child structure. In Oracle Planning and Budgeting Cloud (PBCS), there are seven dimensions out of the box which are Account, Currency, Entity, Period, Scenario, Version, […]
Read more
Image 1: TDATASEG Table Reference
(0) Comments

FCCS Data Management

Using SQL mapping to add a Unique ID to each Record Recently, an **FCCS** client had a need to include a unique identifier to each record of data extracted from their [FCCS application](https://www.mindstreamanalytics.com/fccs.html). This…
Read more
Featured image for Troubleshooting Smart View
(0) Comments

Troubleshooting Smart View

Troubleshooting Smart View While working with Oracle’s SmartView, users may encounter errors or issues. The most common error codes are the following: 1. #NO CONNECTION – You are not connected or logged on to a data source. 2. #INVALID – Invalid metadata. Invalid cells that contain a value display the value as zero. 3. #LOCKED […]
Read more
Client Funds from Operation
(0) Comments

Balance Sheet and Income Statement Accounts in the Same Hierarchy

Balance Sheet and Income Statement Accounts in the Same Hierarchy If you need to put balance sheet and income statement accounts into the same hierarchy and then report on the movements across periods, have…
Read more
(0) Comments

Consolidation in OneStream

Consolidation in OneStream Every company has financial consolidation and reporting needs, and the tools used to address those needs are often driven by the complexity of the company’s structure and source systems. There are three main groups of tools typically used for consolidations and reporting: spreadsheets, general ledger or ERP systems, and purpose-built CPM applications. […]
Read more
(0) Comments

Data and Metadata Load Errors in Data Management

Data Management introduced the ability to load metadata to **Oracle EPM Cloud Services** in the 17.11 update. This functionality provides organizations the ability to leverage a user-friendly platform for loading both data and metadata. Equally important, **Cloud Data Management (CDM)** allows metadata to be transformed using its familiar mapping functionality. However, though this is an […]
Read more
onestream data source screen
(0) Comments

OneStream Concatenating two source fields

Concatenating two source fields When loading source data into OneStream, you may have a requirement where the mapping of a dimension is based on the content of two separate fields in the source. For example, you may have a target Product dimension that is populated based on the combination of the values stored in the […]
Read more