Font size
WorksheetsOneStream Associate Cert Quiz
Total questions: 15
Worksheet time: 9mins
What are two (2) dimensions that can contain dynamically calculated members? Select two.
Scenario
Entity & UDs
Account & Scenario
UDs & Account
What is a benefit of using Literal Value parameters?
Data is hard-coded
VB.Net syntax is automatically converted to the C#
Reduced reporting maintenance
Drop-down lists are easier to create
What are the recommended steps (approach) to utilize the Workflow Excel Metadata Builder Template?
1. Create a Cube Root Profile within OneStream 2. Create Workflow Templates in OneStream for Input Profiles (Import, Forms, Adj) 3. Use the Workflow Hierarchy Builder Excel Template to build the Workflow hierarchy under the Cube Root Workflow Profile
1. Create a Workflow Profile within OneStream 2. Create Workflow Templates in OneStream for Input Profiles (Import, Forms, Adj) 3. Use the Workflow Hierarchy Builder Excel Template to build the Workflow hierarchy under the Cube Root Workflow Profile
1. Create a Cube Root Profile within OneStream 2. Create a Workflow Profile within OneStream 3. Create Workflow Templates in OneStream for Input Profiles (Import, Forms, Adj)
None of the Above
System derived dimensions can be edited and are in the dimension library. True or False?
True
False
Grid view allows you to quickly edit (a) for multiple members in a dimension hierarchy or branch within a hierarchy?
Designer is the default interface when entering cube views? True or False?
True
False
Where is this parameter set up? |!param_costcenter!|
OneStream Parameter
Dashboard Parameter
None of the above
Column/Row Sharing allow you to
Use the same set of rows/columns in a report
Make organizing easier
All of the above
To make a cube view dynamic, where should you start first in the cube view builder?
General Settings
Report Header
POV
Report Footer
Rows and Columns
In the Cube View Builder POV tab, you have to pick a member for all 18 dimension types. True or False?
True
False
In the View Dimension, all data is stored as year to date (YTD) but CAN'T be viewed and retrieved dynamically as needed. True or False?
True
False
In the View Dimension, all data is stored as year to date (YTD) but CAN'T be viewed and retrieved dynamically as needed. True or False?
True
False
The time dimension can be edited and customized after the application is created. True or False?
True
False
Time dimension can be edited through...
(a)
Security on the members in the dimension focus on? (pick 2)
flow
scenarios
entities
accounts
