Forum Discussion

vmanojrc30's avatar
vmanojrc30
Contributor
2 days ago

Dynamically changing a Cube view row to allow Input

I have a requirement to allow users to enter an Annual Plan and spread it across Plan Periods using the spread method they select. Spread Methods are Equal Spread, 4-4-5 Weekly Spread and Manual. When they select "Manual" the cube view should dynamically pick O#Forms as Origin member for Data Entry.

I have the Account and Product in rows with member expansion (.Base). Is there a way to retrieve the Base Account and Product from Cube view dynamically and reference in an XFBR?My plan is to get the Spread method chosen for the Base Account and Product combination and Return the Origin as O# Forms for that row?

Please share any other ideas if you may have implemented for the same requirement?

 

Cube View
dashboards
Reports

2 Replies

  • vmanojrc30's avatar
    vmanojrc30
    Contributor
    1 day ago

    Hi Chris

    Please find below the screenshot and answers to your questions

    Also, when “Manual” is selected:

    Should the cube view refresh in place, with only the selected row’s Origin dynamically switching to O#Forms for data entry?Yes

    Or is there a separate / linked cube view that should open or update instead? No but open for suggestions.

  • Chris-B-AIQOS's avatar
    Chris-B-AIQOS
    New Contributor III
    1 day ago

    Hi,

    Could you please share a screenshot showing how users select the “Manual” spread method?

    Also, when “Manual” is selected:

    Should the cube view refresh in place, with only the selected row’s Origin dynamically switching to O#Forms for data entry?

    Or is there a separate / linked cube view that should open or update instead?

    Chris