Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to add connetions dynamically to a business Object report ?
- Thread starter msnhari
- Start date
I do not believe this is possible.
A report does not connect to a database. It connects to a universe which connects to a database. I do not know of anything in the API that will let you change the connection.
You might be able to change the universe that a query is using via the API, but I'm not sure.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
A report does not connect to a database. It connects to a universe which connects to a database. I do not know of anything in the API that will let you change the connection.
You might be able to change the universe that a query is using via the API, but I'm not sure.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
The legitimate solution is to define connection by the user logging in. For seperate database connections create seperate users and set the proper connection in supervisor (universe tab).
This way you can easily detect within report onto which database you are connecting....
T. Blom
Information analyst
tbl@shimano-eu.com
This way you can easily detect within report onto which database you are connecting....
T. Blom
Information analyst
tbl@shimano-eu.com
- Thread starter
- #4
But Blom,
If there are 20 querries in one report and 50 such reports, then each time I have to change the connections in the report and that too for all the querries. This is what I understand, might be my understanding is wrong.
The universe tab is on the report, right ?
If there are 20 querries in one report and 50 such reports, then each time I have to change the connections in the report and that too for all the querries. This is what I understand, might be my understanding is wrong.
The universe tab is on the report, right ?
No, No , No,
You got that totally wrong. In supervisor go to the universe tab. Create an additional user. Select the universe(s) and select properties. For this additional account set the connection to another database.
Of course this will only work with database that have the same structure (same objectnames, same fieldnames etc)
This is the way we use the same reports on our live warehouse-database AND on the test-database.....
People who log in as TEST_XXX run reports on testdatabase,
XXX runs it on live....
T. Blom
Information analyst
tbl@shimano-eu.com
You got that totally wrong. In supervisor go to the universe tab. Create an additional user. Select the universe(s) and select properties. For this additional account set the connection to another database.
Of course this will only work with database that have the same structure (same objectnames, same fieldnames etc)
This is the way we use the same reports on our live warehouse-database AND on the test-database.....
People who log in as TEST_XXX run reports on testdatabase,
XXX runs it on live....
T. Blom
Information analyst
tbl@shimano-eu.com
- Thread starter
- #6
Blom,
Definetely I have then got it wrong. Actually I am quite new to the BO world. Another basic doubt, where is the supervisor option? I can see only the Universes in the BO application. And under Universes every thing is blank. Please dont mind to give me a step by step process.
Thanks in adv,
Cheers
msn,
Definetely I have then got it wrong. Actually I am quite new to the BO world. Another basic doubt, where is the supervisor option? I can see only the Universes in the BO application. And under Universes every thing is blank. Please dont mind to give me a step by step process.
Thanks in adv,
Cheers
msn,
msn,
BO consists of (among others) reporter,designer and supervisor. The supervisor module lets you create users and is needed for the strategy I was explaining about.
Possible you have only reporter installed , but SOMEONE (possibly IT) will have access to it.
Do you use universes at all I am wondering, are you using full clients, ZABO, or Webintelligence?
T. Blom
Information analyst
tbl@shimano-eu.com
BO consists of (among others) reporter,designer and supervisor. The supervisor module lets you create users and is needed for the strategy I was explaining about.
Possible you have only reporter installed , but SOMEONE (possibly IT) will have access to it.
Do you use universes at all I am wondering, are you using full clients, ZABO, or Webintelligence?
T. Blom
Information analyst
tbl@shimano-eu.com
- Thread starter
- #8
Blom,
We do not use Universe at all. Its only BO Client. Ok, let me tell u the structure here. The BO is refreshed in the live environment using BCA console. But development doesnt have it. We have 15 different development environments and each has its set of oracle user id and password.
The usual way is that to mannually open each report, change the connection string to the repective database and then refresh it. After this the final step to Save it ofcourse.
This is a very very tideous task as you may imagine.
Hence, we have developed a shorter way using Visual Basic. This program opens each report, refreshes automatically and then saves it in a particular path. Our work is though reduced but not minimised as such we will still need to change the connection string in each of the querry(a lot of these) and then run the VB application.
Hence, I wanted to know if we can have a tool in VB where you can specify the connection string and the application automatically takes it, refreshes it and saves the report. Our lives will be saved!!!
Any suggestions for this ? We USE ONLY oracle and BO client.
Cheers
msn,
We do not use Universe at all. Its only BO Client. Ok, let me tell u the structure here. The BO is refreshed in the live environment using BCA console. But development doesnt have it. We have 15 different development environments and each has its set of oracle user id and password.
The usual way is that to mannually open each report, change the connection string to the repective database and then refresh it. After this the final step to Save it ofcourse.
This is a very very tideous task as you may imagine.
Hence, we have developed a shorter way using Visual Basic. This program opens each report, refreshes automatically and then saves it in a particular path. Our work is though reduced but not minimised as such we will still need to change the connection string in each of the querry(a lot of these) and then run the VB application.
Hence, I wanted to know if we can have a tool in VB where you can specify the connection string and the application automatically takes it, refreshes it and saves the report. Our lives will be saved!!!
Any suggestions for this ? We USE ONLY oracle and BO client.
Cheers
msn,
Man, believe me, you are on the wrong track working with just direct SQL statements. The whole point of universes is to minimize the whole exercise you have to go through (I hope Steve will back me up on this) However set this up in the first place deserves a thrashing it seems. Hope you find a solution through VB (can't imagine one though) but my suggestion would be to go for a proper universe with each developmentteam having their own accounts.
You are not serious in going into production with documents solely based on bare SQL?
You'll regret it, believe me...........
Working with universes offers SO MUCH compared to working with raw SQL, I am absolutely speechless on this one.....
T. Blom
Information analyst
tbl@shimano-eu.com
You are not serious in going into production with documents solely based on bare SQL?
You'll regret it, believe me...........
Working with universes offers SO MUCH compared to working with raw SQL, I am absolutely speechless on this one.....
T. Blom
Information analyst
tbl@shimano-eu.com
- Thread starter
- #10
Universes have nothing to do with the size of your database, it allows users an interface so they do not have to think up their SQL themselves, since objects and joins are already taken care of. I do not mean to talk down to you, but working just with bare SQL you could have done with a much simpler tool and probably saved many pennies.
Anyway lots of succes , hope someday your company will get the true picture of what can be achieved with BO
T. Blom
Information analyst
tbl@shimano-eu.com
Anyway lots of succes , hope someday your company will get the true picture of what can be achieved with BO
T. Blom
Information analyst
tbl@shimano-eu.com
I have to agree with my friend, tblom.
You are in for a very painful time. Free-hand SQL is a nightmare to maintain and build. Universes give you so much flexibility. Free-hand SQL is merely in BO as a convenience. It is NOT intended to be used in a production environment. That's why Free-hand SQL connections are not secured in the repository.
You are in for a very painful ride. Your implementation does not follow any of the best practices.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
You are in for a very painful time. Free-hand SQL is a nightmare to maintain and build. Universes give you so much flexibility. Free-hand SQL is merely in BO as a convenience. It is NOT intended to be used in a production environment. That's why Free-hand SQL connections are not secured in the repository.
You are in for a very painful ride. Your implementation does not follow any of the best practices.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
- Status
Similar threads
- Locked
- Question
- Locked
- Question