Hyperion EPM General (MOSC)

MOSC Banner

How to restrict data updates on period dimension when retrieving data in SmartView

edited Dec 5, 2023 8:34PM in Hyperion EPM General (MOSC) 1 commentQuestion

Hello everyone,

I'm on 11.2.8 on-prem version and the application is planning based, however users now would need to only utilize SmartView Essbase connections for data updates and retrieves. Users are utilizing only SmartView to work on their Actuals, Forecast and Budget.

The security is currently based on the scenario, version, account, entity. I tried to create filter in Essbase EAS console, but unable to assign them in shared services under the Planning group.

create filter 'Appname'.'dbPLAN'.'App_PriorActualsLocked' 

read on '&App_LockedMonths, @IDESCENDANTS ("Years")',

write on '&App_CurrMth, &App_CurrYr'

grant filter 'Appname'.'dbPLAN'.'App_PriorActualsLocked' to group 'App_PriorActualsLocked';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center