Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Analysis based on random Query from table

Received Response
1
Views
1
Comments
4205331
4205331 Rank 1 - Community Starter

Dears

I have table for example  (Table 1) like below

ID     Name        Select

----     -------       ----------

1          A          Select C1. C2 from x

2          B          Select col4, Col6 from y

I'll make analysis to show above table and insted to show the select text I need to make a link to run the query in deterrent analysis based on row id.

Note each row has different select statement.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Honestly you got us completely stumped. Why on earth do you use OBI if you don't use it as designed?

    Write an SQL parser in PL/SQL and stop wasting money on expensive licenses.

    In other words: stop trying to "drive" a Ferrari by tieing a moose to it an hitting the moose with a sledgehammer made of marshmallows. It's just non-sensical