Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do i integrate Data Studio into Apex

User_JB4KJSep 14 2021

I am trying to connect my code from data studio into an Apex screen. Is this possible and if so how can I do that?

Comments

Gianni Ceresa

If you inspect the HTML behind the "columns format" of your prompts you will see each columns of prompts his a <td> of a main table. So you can add some custom CSS to change alignment and size of that main table and the 4 <td>.

You can probably also try a less "clean" solution like adding lot of spaces in front of the longer label of the 2nd, 3rd and 4th columns to "push" the others columns a bit more.

There aren't lot of available settings for how prompts must look like, but it's HTML, so with JS or CSS you can change the way it looks like...

I would only advice to not make anything too complicated also because you have the risk the HTML code change with a future release of OBIEE.

Also try to just align the prompts centrally, they will maybe look a bit better with less empty space on the left.

Capture.PNG

Daniel Willis

I managed to make checkboxes go horizontal instead of vertical using JS/CSS a while back but unfortunately every time I changed the value in a prompt it would refresh them and not redo my JS. I stopped there because I was doing it more for interest rather than anything else.

Gianni Ceresa

@"Daniel Willis" : time to move to 11.1.1.9, horizontal checkboxes / radio buttons are there out of the box (Rittman Mead Consulting » OBIEE 11.1.1.9: New Features for Front-End Developers and Business Users > "Horizontal Layout for Radio Button and Check Box Dashboard Prompts")

2804071

To spread out between columns in PROMPTS, is possible to add a character that is not visible but takes up space (normal space is ignored), use alt + 255.

While holding down the alt key, write 255 in the numeric keypad (on the right). Release the alt between each character.

1 - 4

Post Details

Added on Sep 14 2021
1 comment
152 views