What is the Query to export all objects to LCMBIAR

[former_member525841]

Hello,

We have developed an LCMBIAR script to save existing objects in SAPBO 4.1 something we do at the beginning by promotion management to save the objects as in the screenshot,

biar.jpg

the following request was used:

select * FROM CI_INFOOBJECTS

This request to generate a file, when it was imported into promotion management, we noticed that it does not contain the totality of the objects (Universe, reports, users, groupusers, Connection ....) ,

Can you please send us the correct request to save all BO Objects,

[DellSC]

If you want everything you'll need to include CI_APPOBJECTS and CI_SYSTEMOBJECTS in addition to CI_INFOOBJECTS. However, you don't really want everything because that would include servers and other objects that are specific to your system.

One option when using the command line tool is to use the parameter:

exportDependencies=true

This will export to the file any universes, connections, etc that are used by the report(s).

To get users, groups, and security you'll include this parameter:

includeSecurity=true

If you don't want to do it that way, you'll need to include multiple queries in your parameter file and then limit them by the SI_KIND of the objects you want to include in the file. For example, to get universes and connections, you'll run a query like this:

Select * from CI_APPOBJECTS where SI_KIND in ('Universe', 'CCIS.DataConnection', 'MetaData.DataConnection')

I've attached a text file that contains a list of most of the types of objects and which table they're in (add "CI_" to the table name.) Note that the "Connection" that's in CI_APPOBJECTS is a user's connection to BO, NOT a database connection!

bokindlist41.txt

There's also a section in the Admin Guide that talks about how to use the command line that has definitions of all of the parameters that are available.

-Dell

[ayman_salem]

Hi Souhail,

if you import the backup with "CMC --> Promotion Management", and the backup has many files (as I can see from your screenshot), you should first copy all backup files to the temporary directory (in your case, c:\windows\temp), then import it. and it will work

Ayman

[denis_konovalov]

Looks like you need Promotion pattern book from here

https://wiki.scn.sap.com/wiki/display/BOBJ/Business+Intelligence+Platform+-+Pattern+Books+Index

It has real life examples.


Please note - what you are trying to do is a band aid in place of a proper backup. It will not work reliably as a backup solution.

[former_member525841]

i.jpgWhen I tired to import the buckup we get the error message bellow :

*********************************************************************************

Sorry, Promotion management application is unable to process your request.
The error from the server is: Unable to retrieve Job from the selected file. Please check the file.(PRS 00009)Input/output exception occurred : 'C:\Windows\TEMP\backup_temp11.lcmbiar (The system cannot find the file specified)' (FWM 04013) JobFromFileFailed

**********************************************************************************

[denis_konovalov]

does the user which runs your import has access to this location/file ?

how big this lcmbiar is?
If you created this lcmbiar via CLI - you won't be able to import it with GUI PM.