Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Amarnath Govindu
    BIP Report Parameters
    Topic posted May 10, 2019 by Amarnath GovinduBronze Medal: 1,250+ Points, tagged BI Publisher, OBIEE Answers, Reports, Tip 
    72 Views, 3 Comments
    Title:
    BIP Report Parameters
    Summary:
    BIP Report Parameters
    Content:

    Hi -> BIP Report Parameters:
    Can we make BIP report parameters in the required order if there are more parameters.
    Ex: I have 20 parameters which I need to show them from 2 columns.

    Column1                 Column2              Column3
    ------------------------------------------------------
    Parameter1           Parameter2           Parameter3
    Parameter4           Parameter5           Parameter6
    Parameter7           Parameter8           Parameter9
    Parameter10          Parameter11          Parameter12
    Parameter13          Parameter14          Parameter15
    Parameter16          Parameter17          Parameter18
    Parameter19          Parameter20

    When I am trying to keep in the above order the order is missing.
    We have an option called Row Placement from which we can place a
    parameter to the row but facing issues with column alignment.

    Let me know if any one coma across this situation?

    Version:
    11.1.1.9.0

    Comment

     

    • Alexey Shtrakhov

      I think you have to create these parameters in this order and mark following row placement:

      Parameter1         Row1
      Parameter4         Row2
      Parameter7         Row3
      Parameter10        Row4
      Parameter13        Row5
      Parameter16        Row6
      Parameter19        Row7

      Parameter2         Row1
      Parameter5         Row2
      Parameter8         Row3
      Parameter11        Row4
      Parameter14        Row5
      Parameter17        Row6
      Parameter20        Row7

      Parameter3          Row1
      Parameter6          Row2
      Parameter9          Row3
      Parameter12        Row4
      Parameter15        Row5
      Parameter18        Row6

       

      • Amar

        Hi-> If my parameters should like below, 

        Parameter1   Parameter2  Parameter3
        Parameter4   Parameter5  Parameter6
        Parameter7   Parameter8  Parameter9
        Parameter10  Parameter11 Parameter12
                            Parameter13 Parameter14
                                                Parameter15
                                                Parameter14

         

        Is it possible to show above format?

        Thanks

         

        • Alexey Shtrakhov

          Then you do this like this:

          Parameter1         Row1
          Parameter4         Row2
          Parameter7         Row3
          Parameter10        Row4
          Parameter2         Row1
          Parameter5         Row2
          Parameter8         Row3
          Parameter11        Row4
          Parameter3          Row1
          Parameter6          Row2
          Parameter9          Row3
          Parameter12        Row4
          Parameter13        Row1
          Parameter16        Row2
          Parameter19        Row3
          Parameter14        Row4

          The main point is that they will be placed in order and following the row placement

          Alexey