<!DOCTYPE html> <html> <head> <style> #myImg { border-radius: 5px; cursor: pointer; ...
Read More
Enter key word
Home / BICS
Showing posts with label BICS. Show all posts
Showing posts with label BICS. Show all posts
OBIEE Prompt for BIP Report - Passing Multiple Values along with Passing All Values
For the OBIEE prompts to be used for BIP reports and to pass (All Column Values) and also multi select you can use the following SQL in the...
Read More
Display Previous N period in MON-YY format
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_Period FROM dual CONNECT BY LEVEL < 5 order by (TO_CHAR(A...
Read More
Subscribe to:
Posts
(
Atom
)