BO POPUPS and List of Values

building semantic layer
1

Hello,

I have migrated reports from one database to another (DatabaseB).
However I am having problems with POPUPS with the new database.

I have an Object in the universe with this select:

DatabaseB.POPUP(‘Boolean’,DatabaseB.BOUSERINFORMATION.CANCHANGEPRICESPN)

When I try to Parse this I am told that - DatabaseB.POPUP is an invalid identifier.

ALso when I look at the Object properties although it has a list name (where is this list held?) when I try to Display I have an SQL sentence error.

Any Suggestions??

many thanks in advance

MIDZ (BOB member since 2010-04-07)

2

What RDBMS are you using?

Is POPUPS a function that was created in one database but that either:

  • does not exist in the new database or
  • the connection account has not been granted execute on?
3

Hi,

The RDBMS is Oracle.

The POPUP function was created in the original database which I migrated the Universe from. The Object is still pointing at the Original database but when I try to change it I have an error message.
Surely the POPUP function (if it is a function?) would have been migrated too with the import of the universe?

Many Thanks

MIDZ (BOB member since 2010-04-07)

4

The POPUP is not a function since it does not have @ in front of it.

Thanks

MIDZ (BOB member since 2010-04-07)

5

Database functions (or tables, views, stored procedures, database indices, etc.) are NEVER migrated with a universe. That is something one must take care of separately on the database side.

Andreas :de: (BOB member since 2002-06-20)

6

That simply means that it is not a BusinessObjects function, which we know it isn’t!

It is a database function that needs sorting out as we have said.

7

Thank you for that!

Will try to change the Database function.

MIDZ (BOB member since 2010-04-07)