Skip to main content
Archana
Newcomer
Feb 27, 2025 4:48 PM UTC

Cube View

Hi,

I'm trying to create a form with set of accounts in rows and column should be for adding the adjustments. Here, I do not required to pull any data from the cube. Instead I have to update the adjustments based on the scenario selected. This should be a separate form where the adjustments data should not update the existing forecast data.

POV:

 

 

 

 

 

 

Parameters in POV are defined to pull the accounts accordingly.

Rows: 

Columns:

Issue:

I couldn't get the form with editable fields. refer screenshot below.

FYI: Can Modify data for Column is set to 'True'

 

14 replies

1392
Member
Feb 27, 2025 5:07 PM UTC

Hello,

How about Flow and Origin members being defined in POV? Or the defined but missed in screenprint.

Thank you

ArchanaAuthor
Newcomer
Feb 27, 2025 5:10 PM UTC

I've updated POV like this. refer this screen print.

1392
Member
Feb 27, 2025 5:14 PM UTC

If everything is a base member it should unless you have a slice security restriction, or the scenario being locked for 2024.

ArchanaAuthor
Newcomer
Feb 27, 2025 5:17 PM UTC

scenario not locked. Same issue even if I choose any scenario in 2025.

1392
Member
Feb 27, 2025 5:20 PM UTC

how about the current security setup.

ArchanaAuthor
Newcomer
Feb 27, 2025 8:43 PM UTC

Hi all,

I gave V#Annotation in the column member filter and it worked. S#|CVScenario|:Name(Forecast Adjustments):V#Annotation

 

TGG_Alex
Member
Feb 28, 2025 1:01 PM UTC

I would caution on use of V#Annotations:

  1. This v# member is intended to capture text commentary
  2. Security over these members do not obey regular cube security
  3. This breaks data lineage with regular v# members such as Periodic and YTD

If it is a numeric adjustment , then you probably have another rule to move the adjustment from that member elsewhere?

Just my two cents.

 

ArchanaAuthor
Newcomer
Feb 28, 2025 1:44 PM UTC

I removed V#Annotation from column member filter. But instead in POV I added Annotation for View then only the form becomes editable otherwise it is not.

currently I have like this. 

Is this ok to do? my difficulty is the column fields is not accepting any numeric format, for Total Revenue even though I set Can Modify as 'False' it is editable.

TGG_Alex
Member
Feb 28, 2025 10:11 PM UTC

Btw, this looks like a duplicate thread to:

Cube View Group - Forms | OneStream Community

Try merging these so you can concentrate the community response and avoid duplicate effort. 😀

    Terms & ConditionsAccessibility statement