Showing dynamic data over image in OBIEE

There was a requirement in which we needed to show report’s data on a static image. This Image was provided by client and we had to place the tables of 4×2 on multiple places on this image. In image (refer below image) you will see Rectangles in different colours which are static, but values shown under those rectangles are dynamic. These values are changing as per there is a change in data in ETL table. To overcome as a solution of this requirement we took help of html code. Here is the step by step guide to implement the same.

show_dynamic_value1

  1. Criteria:go to criteria tab and drag and drop columns for which you want to show data on image.show_dynamic_value2
  2. Create one column called ‘Style’ for the position of different boxes on Image. This is how 8 different positions were created. No of positions may vary for your project. you can change the px values to change the position of objects on image.show_dynamic_value3
  3. Then use ‘Narrative View’show_dynamic_value4
  4. you can take reference from below code:Prefix: show_dynamic_value6Note: Image shown is placed at a path mentioned above. This path may be different for different projects

    Narrative: show_dynamic_value5

     

    Highlighted texts:

    color:red it is a tag for Red coloured box and @2 and @4 are referring to the columns in criteria which to be shown in row corresponding to red box: @2 and @4 are referring to two different columns, Internal and External respectively.

    Like wise this is done for other coloured boxes.

    Row seperator : </div>

    Post fix : </div>

    Please share your thoughts if it helped and keep watching this space for more updates.You can follow me on twitter (@akashdgarg) for quick updates about what’s happening in the area of BI, Big data, OBIEE etc.

Continue reading

Advertisements