I posted this last week…anyone have a suggestion for this yet? Thanks.
Hi Listers,
I’d like to create some objects in my universe that my users can add to the bottom of each report they create. The objects would identify the following:
The Universe long name and file name
The Connection being used
The username for the connection
The Database the user is connected to
The server the user is connected to
Can anyone tell me how to do that? I’m thinking I probably need to use some of the tables from BOREP but have no idea what tables or columns would give me this info.
I know how to get this infromation using the full client and the document or universe functions but I’d prefer to make it easier for the users by creating standard objects that would be required on all reports. (We are using V5.0.1 with NT and Sybase) Thanks in advance for any help you can give me. Shannon Wittal
Quad/Graphics, Inc.
I’d like to create some objects in my universe that my users can add to the bottom of each report they create. The objects would identify the following:
The Universe long name and file name
The Connection being used
The username for the connection
The Database the user is connected to
The server the user is connected to
I’m new to BusObjs, but based on a previous response from Dave Rathbun, I was able to add an object to a universe to return the username (#3 above). In the universe, I added a dimension object with the following parameters:
Name: Connected User
Type: Character
Select: @Variable(‘BOUSER’)
I did not select a table. The object doesn’t parse OK, but I could still use it in a report. Here’s why (I stole some verbiage from Dave):
When you select this object in a query/report the generated SQL will look like: Select @Variable(‘BOUSER’) From
… which will fail to parse. However, as long as the user puts this object on a query with at least one object that does reference a table, the generated SQL will look like: Select @Variable(‘BOUSER’), Table.Column From Table I tested this and it worked. BOUSER is a BusinessObjects system variable. I can’t find a list of others, but maybe there are more that you can use for the other objects you want to generate. Hope this helps!
Paula J. Guillory
Decision Support Analyst
Chevron Chemical Company, LLC
713-754-5759
I’m pretty sure that you would struggle to do this.
You could probably access the repository tables to get various bits of information, but how would you access your warehouse/mart plus the repository? BO does not support multiple connections.
You can add universe objects using @Variable(’’). The system variables I know of are BOUSER and BOPASS, though the documentation says that there are more that relate to connections. However, I have never been able to get these to work.
The best way is to use the data provider functions in the document. I know this isn’t exactly intuitive for novice users, but such is life.
You can create formulas (or variables) in a column or cell of a report. BO provides some of these functions. When you’re in the formula editor, you should see different categories of functions. For example:
Data provider functions includes:
Connection()
UniverseName()
Misc functions includes:
CurrentUser()
Maybe you can create a template with cells in the footer of the report using these functions.
Paula Guillory
Chevron Chemical Co, LLC
713-754-5759 pgui@chevron.com
Steve,
Are you referring to using VBA within the document to access some data provider functions?
Kathy Vazquez
Hi,
I’m pretty sure that you would struggle to do this.
You could probably access the repository tables to get various bits of information, but how would you access your warehouse/mart plus the repository? BO does not support multiple connections.
You can add universe objects using @Variable(‘’). The system variables I know of are BOUSER and BOPASS, though the documentation says that there are more that relate to connections. However, I have never been able to get these to work.
The best way is to use the data provider functions in the document. I know this isn’t exactly intuitive for novice users, but such is life.
Steve
From: Shannon [SMTP:swittal@EXECPC.COM]
I’d like to create some objects in my universe that my users can add to the
bottom of each report they create. The objects would identify the following:
The Universe long name and file name
The Connection being used
The username for the connection
The Database the user is connected to
The server the user is connected to
Can anyone tell me how to do that? I’m thinking I probably need to use
some of the tables from BOREP but have no idea what tables or columns would
give me this info.
In a message dated 00-03-15 06:31:47 EST, you write:
The Universe long name and file name
The Connection being used
The username for the connection
The Database the user is connected to
The server the user is connected to
Can anyone tell me how to do that?
How about using your own table instead of the repository tables? Simply add a table to your schema with the information you require, then build objects off of that table. It could even include things like last refresh date (for the warehouse) or other “goodies”.
I think this would be easier. As someone else has already mentioned, unless your database for user data is using the same connection as your repository, you are going to have problems getting to the data anyway.