Skip to main content
A
Archana
Newcomer
February 27, 2025

Cube View

  • February 27, 2025
  • 4 replies
  • 0 views

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'

 

4 replies

1
1392
Newcomer
February 27, 2025

Hello,

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

Thank you

A
ArchanaAuthor
Newcomer
February 27, 2025

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

1
1392
Newcomer
February 27, 2025

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

A
ArchanaAuthor
Newcomer
February 27, 2025

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

1
1392
Newcomer
February 27, 2025

how about the current security setup.

A
ArchanaAuthor
Newcomer
February 27, 2025

Hi all,

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

 

T
TGG_Alex
Newcomer
February 28, 2025

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.

 

A
ArchanaAuthor
Newcomer
February 28, 2025

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.

T
TGG_Alex
Newcomer
February 28, 2025

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