Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Convert a row into columns

758537Jun 1 2010 — edited Jun 1 2010
Hello Experts,

I have data that looks like :-

field1 field2
1 a,b,1,c,3,4
2 e,3,4,d,f,g

I want a query which would output the data as
field1 field2
1 a
1 b
1 1
1 c
1 3
1 4
2 e
2 3
2 4

etc

Any help would be appreciated.

Thank you
This post has been answered by BluShadow on Jun 1 2010
Jump to Answer

Comments

663750
hello Micros,

If you have small project its beneficial to use Single repository

and the main advantage to have a Single repository is the execution speed ,

If you are using multiple rep its difficult to merge them and the speed is very low
631335
Hello Micros

I have made an installation with one BI Server with multiple repositories, served by multiple presentation services, on Oracle Unbreakable R4. It is a little bit tricky but it works.
663712
Can you share how you did it? What was the tricky part?
631335
Answer
I'm going to write a document about this sometime in the future.
Right now these are some basic steps:

1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
3. Add new repository on NQSConfig.Ini and restart BI Server
4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
You can also check the following links
[http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
[http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

Giorgio
Marked as Answer by 663712 · Sep 27 2020
663712
Awesome! Thanks
David_T
Wow. After all that, no points for Giorgio?!
667465
Hi Giorgio
Do you have the document, since i have tried almost everything but i am still not able to do it.
Here is the link where i have written all the steps please correct them if you find any mistake or please add steps if in case you find it missing.
link : 3715965

I badly need to try this, because people dont believe that this can be actually done.

thanks
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 29 2010
Added on Jun 1 2010
6 comments
1,359 views