Forum Stats

  • 3,839,213 Users
  • 2,262,466 Discussions
  • 7,900,898 Comments

Discussions

PBCS - Change display in form

3235756
3235756 Member Posts: 129
edited Sep 14, 2016 4:31AM in Planning and Budgeting

I have setup this form:

pastedImage_2.pngpastedImage_6.png

But I want to change the display like this (an unique column with the value of entity):

pastedImage_7.png

                                                                                                                      

1101 COMPRAS Y TRABAJOS EXTERIORES1218 LOGÍSTICA
FY16FY15FY15FY14FY16FY15FY15FY14….
FORECASTFORECASTREALREALFORECASTFORECASTREALREAL….
6210. ARRIENDO LOCALES
6210.01   ARRIENDO INSTALAC

How can I setup this form?

Tagged:

Best Answer

Answers

  • USER1211
    USER1211 Member Posts: 3,104
    edited Sep 12, 2016 10:33AM

    Do it your Data Form Design.

    Have column with the entity,scenario and the year members then have another column with the other entity,scenario and the other year members.

    Once you got the clarity you needed remember to mark the thread as answered so members can focus on unanswered questions.

    Did Your Question Get Answered in My Oracle Support Community (Doc ID 1180503.1)

  • 3235756
    3235756 Member Posts: 129
    edited Sep 13, 2016 6:10AM

    I want that the column of "entity" dimension (1101, 1218) shows only once like this example:

    pastedImage_3.png

    If I create some columns, the entity repeats. For my example, the column 1101, I want that shows once and now Entity shows 3 times:

    pastedImage_0.png

    pastedImage_1.png

    Further, I don't want to view all years and all scenarios. There are these situations:

    • FY16 and FY15 for "Presupuesto" Scenario
    • Only FY15 for "Real" Scenario
    • Only FY14 for "Presupuesto" Scenario
  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Sep 13, 2016 6:24AM Answer ✓

    You may not get it exactly how you want it but here is an example similar to yours.

    pastedImage_1.png

    pastedImage_0.png

  • 3235756
    3235756 Member Posts: 129
    edited Sep 14, 2016 4:03AM

    Thanks, this option tried, but the problem is that I have a lot of members entity (sales east, international sales).

    I wanted to know if PBCS had a option to avoid: add entity by entity in the form, and not repeat the member in the view (for example, "sales east" displays in two columns).

    At the moment, I will use this option

  • AL.
    AL. Member Posts: 265 Blue Ribbon
    edited Sep 14, 2016 4:26AM

    Hello,

    From my point of view, it seems like you need a report instead of a webform.

    Finnancial reporting studio gives you many more posiblities regarding the design and display options. You can merge cells, asign colours or even change the writing font...

    Best Regards,

    3235756
  • 3235756
    3235756 Member Posts: 129
    edited Sep 14, 2016 4:28AM

    Thanks, I going to explorer "Finnancial reporting studio" option.

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Sep 14, 2016 4:31AM

    You can only customise the form with the options that are available, as I said it may not always be exactly the format you are looking for.

    There are many different ways of doing things you could have entity in the page and then with security the user will just enter data for the entity they have access permissions against.

    Also it depends if this is a data entry form or a report which as suggested could be done through FR if it is.

    3235756
This discussion has been closed.