Inforiver
Premium Table
Premium Table
  • Introduction to Premium Table
    • Get Started
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Premium Table
    • 1. Build your first Inforiver Table report
    • 2. Displaying information
      • Report interface
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
        • Importing data
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Budgeting & allocations
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad hoc emails
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • ROUNDDOWN
      • ROUNDUP
      • MROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Statistical Functions
      • RANK
      • RANKEQ
      • RANKAVG
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Accessibility shortcut keys
Powered by GitBook
On this page
  • 1. Admin
  • 2. Contributor
  • 3. Passive Viewer
  • 4. Input Admin
  • 5. Input User
  • 6. Writeback Admin
  • 7. Forecast Admin
  • 8. Subscription Admin
  • 9. Subscription User
  • 10. Infobridge Admin
  1. Admin Console
  2. User management

User Roles and Permissions

The table below lists the default user roles available in the Inforiver console, along with their associated permissions.

Roles
Permissions

Admin

Complete control within the product

Contributor

Member users have been migrated to this policy

Passive Viewer

View-only access to reports

Input Admin

Can create visual measures, modify data input settings and execute writeback

Input User

Can create data input entries, add comments, create bridge and execute writeback

Writeback Admin

Complete control over writeback settings

Forecast Admin

Can create forecast, bridge, input data entry and execute writeback

Subscription Admin

Create and manage subscriptions at tenant level

Subscription User

Create and manage report subscriptions

Infobridge Admin

Can create folders, enter data input and execute writeback

Let's look at the permissions in detail for each profile.

1. Admin

Admins have complete control within the product. They have full access to all report-level features and can manage their associated settings, such as data input, forecast, scenario, snapshot, writeback, subscriptions, etc.

They have access to the Admin Portal, where they can add or remove users, manage their roles and policies, create and define custom roles and policies, and manage general settings, writeback settings, and available assets.

2. Contributor

The existing 'Member' users have been transitioned to the 'Contributor' role. They have access to all report-level features and their associated settings.

They do not have access to the admin portal, so they cannot manage users or change the general and other assets, as well as writeback settings available in the console.

3. Passive Viewer

Passive viewers have read-only access to reports. You can assign this role to users who only need view-only access.

4. Input Admin

Input admin can not only create visual measures, but also change data input settings and perform writebacks. They have the following permissions:

Writeback: Execute writeback

Input:

  • Create and manage data input

  • Configure data input settings and create measures

Comments: Add and manage comments

Forecast: Create and manage forecasts

Snapshot: Create and manage snapshots

Infobridge: Create and manage bridges

Scenario: Create and manage scenarios

Filter context: Configure Filter context settings

5. Input User

Input users can create data input entries, add comments, create bridges, and execute writeback. They cannot modify data input-related settings.

Writeback: Execute writeback

Input: Create and manage data input

Comments: Add and manage comments

Forecast: Create and manage forecasts

Snapshot: Create and manage snapshots

Infobridge: Create and manage bridges

Scenario: Create and manage scenarios

Filter context: Configure Filter context settings

6. Writeback Admin

A writeback administrator has complete control over all writeback settings and configurations, as well as the ability to perform writebacks. Their other permissions include:

Input: Create and manage data input

Comments: Add and manage comments

Forecast: Create and manage forecasts

Snapshot: Create and manage snapshots

Infobridge: Create and manage bridges

Scenario: Create and manage scenarios

7. Forecast Admin

A forecast admin can create and manage forecasts, bridges, input data entries, and execute writeback. They can also configure forecast settings. Other permissions include:

Writeback: Execute writeback

Input: Create and manage data input

Comments: Add and manage comments

Snapshot: Create and manage snapshots

Infobridge: Create and manage bridges

Scenario: Create and manage scenarios

Filter context: Configure Filter context settings

8. Subscription Admin

A subscription admin can create and manage subscriptions at the tenant level. They can configure all subscription-related settings. They do not have any other permissions.

9. Subscription User

A subscription user can create and manage report subscriptions. They do not have access to any other features and settings.

10. Infobridge Admin

Infobridge admins can create and manage folders in Infobridge, enter data input, create and manage bridges, and execute writeback. Other permissions include:

Writeback: Manage and execute writeback configurations

Input: Create and manage data input

Comments: Add and manage comments

Forecast: Create and manage forecasts

Snapshot: Create and manage snapshots

Scenario: Create and manage scenarios

In addition to these default roles, workspace admins can create custom roles and policies on a granular level, ensuring enhanced data governance and security.

This is explained in the next section.

PreviousUser managementNextCreate custom roles and policies