BO SPM - Connecting to a new Bex Query

[former_member190936]

Dear Experts,

For meeting certain new requirements, we have to create a new BEx Query, and have to integrate the same with SPM.

Can you please provide steps to integrate a new BEx Query with SPM ? How will the dimension and measure of new BEx Query will show up in SPM ?

Regards

Pankaj

[pavan_kumaryanmanagandla · Accepted solution]

Hi Pankaj,

This should be pretty simple.

In SPM Home Page, under "Administration", click on "Analysis Administration"

This should open a tabwith all existing datasources.

Click on new (popup opens) and add the new BEx Query with its technical name --> Click on Connect (Shows Connected on success) and configure its time dimensions --> OK to close popup --> Save in the Tab and restart SPM.

After restart, Go to Preferences (Top Right corner of the application) --> Report --> Datasource --> Select the new BEx Query and OK

Now, click on "Create Report" on SPM home to open an untitled report on this new query.

Note:- SPM cannot run Input mandatory BEx Queries.

Regards,

Pavan

[former_member190936 · Accepted solution]

Thanks for help. Yes I found It out later on.

Regards

Pankaj