tableowner.tablename help

building semantic layer
1

How can I get the tables in designer to not display the owner?

All of my tables show tableowner.tablename and I would like to see just the tablename.

Thanks,

Janie

Listserv Archives (BOB member since 2002-06-25)

2

Hi Janie,

  1. Select all the tables by clicking from Edit menu and right click on the table name (any one)
  2. Select Rename Table Name
  3. You will see the owner group and you need to delete the owner group and click on OK.
    It will remove your owner group name for all the tables.

Hope it helps.

Thanks
Ravi.

From: “Pflaum, Janie” janie.pflaum@DOT.STATE.WI.US How can I get the tables in designer to not display the owner?

All of my tables show tableowner.tablename and I would like to see just the tablename.

Thanks,

Janie

Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

3

But isn’t there a way you can set this as default to not show the tableowner?

Hi Janie,

  1. Select all the tables by clicking from Edit menu and right click on the table name (any one)
  2. Select Rename Table Name
  3. You will see the owner group and you need to delete the owner group and click on OK.
    It will remove your owner group name for all the tables.

Listserv Archives (BOB member since 2002-06-25)

4

Janie,
In the BusinessObjects files, the parameters in the PRM file corresponding to your RDBMS indicate how the qualification of tables can be managed.

In the General Section of the file there are two parameters for this :

OWNER=N
QUALIFIER=N

Try this out.

Regards,
Durgesh

How can I get the tables in designer to not display the owner?

All of my tables show tableowner.tablename and I would like to see just the tablename.

Thanks,

Janie

Listserv Archives (BOB member since 2002-06-25)

5

Thanks to all who have responded. I truly appreciate your quick responses.

Janie

Hi Janie,

  1. Select all the tables by clicking from Edit menu and right click on the table name (any one)
  2. Select Rename Table Name
  3. You will see the owner group and you need to delete the owner group and click on OK.
    It will remove your owner group name for all the tables.

Hope it helps.

Thanks
Ravi.

Listserv Archives (BOB member since 2002-06-25)

6

Still didn’t work.

We are using db2, there are 5 prm files in our bo\data access\db2 folder. We’ve changed the suggested settings to no and when we import tables it still has the owner name.

Any other thoughts?

Janie,
In the BusinessObjects files, the parameters in the PRM file corresponding to
your RDBMS indicate how the qualification of tables can be managed.

In the General Section of the file there are two parameters for this :

OWNER=N
QUALIFIER=N

Try this out.

How can I get the tables in designer to not display the owner?

All of my tables show tableowner.tablename and I would like to see just the tablename.

Thanks,

Janie

Listserv Archives (BOB member since 2002-06-25)