Skip to Content

                                                ‘X’ Unx Universe Issue in BO 4.0

Issue

User is trying to create few test reports using the UNX version of the universe. They have encountered couple of issues which is listed below

1.       While generating the WebI report based on ‘X’ universe. It is throwing the below error.

1 sap.png

2.       While generating the Dashboard report, getting the  below error

2 sap.jpg

Solution:-

We need to modify the prompt filter definition in the join condition. The ‘ X’ universe table join contains the below prompt filters in 16 different places.

Ø  ADMIN.V_DWH_GEOGR_ORG_DIM.SLS_FORC_CD  IN @Prompt(‘Enter Sales Force:’,’A’,’Organization Sales Force\Sales Force Code(For Cust Align Prompt)’,MULTI,CONSTRAINED,PERSISTENT)

Ø  ADMIN.V_DWH_ALL_GEOGR_ORG_CUST_ALIGN_REL.CUST_ALL_ALGN_TYP=@Prompt(‘Enter Customer Alignment Type:’,’A’,{‘CURRENT CUSTOMER ALIGNMENT’,’CALL PLAN ALIGNMENT’,’TARGET UNIVERSE CALL PLAN ALIGNMENT’,’CUSTOMER TERRITORY SEGMENT ALIGNMENT’,’CUSTOMER TERRITORY PRODUCT SEGMENT ALIGNMENT’},MONO,CONSTRAINED,PERSISTENT) )

Ø  ADMIN.V_DWH_PRDCT_HIER_PRDCT_DIM.MRKT_LVL_PRDCT_NM IN @PROMPT(‘Enter Market(s): ‘,’A’,’Market\Market Name’,multi,constrained,persistent))

Changes applied on ‘X’ unx format Universe are mentioned as below

Ø  Create  the  List of values in the data foundation layer for object which was referring into prompt (Cust Align (static lov), Market Name (custom sql) & Sales force code (custom sql))

Ø  Create the parameter in the data foundation layer for prompt objects. Refer the lov which was created above.

Ø  Change the prompt definition as @Prompt (parameter Name) for example @prompt (Market Name).The change needs to be applied  into the all join condition (16 prompt Filter)

Ø  Save and close the data foundation and export the Business layer into the repository

Before changes:-

Ø  ADMIN.V_DWH_GEOGR_ORG_DIM.SLS_FORC_CD  IN @Prompt(‘Enter Sales Force:’,’A’,’Organization Sales Force\Sales Force Code(For Cust Align Prompt)’,MULTI,CONSTRAINED,PERSISTENT)

Ø  ADMIN.V_DWH_ALL_GEOGR_ORG_CUST_ALIGN_REL.CUST_ALL_ALGN_TYP=@Prompt(‘Enter Customer Alignment Type:’,’A’,{‘CURRENT CUSTOMER ALIGNMENT’,’CALL PLAN ALIGNMENT’,’TARGET UNIVERSE CALL PLAN ALIGNMENT’,’CUSTOMER TERRITORY SEGMENT ALIGNMENT’,’CUSTOMER TERRITORY PRODUCT SEGMENT ALIGNMENT’},MONO,CONSTRAINED,PERSISTENT) )

Ø  ADMIN.V_DWH_PRDCT_HIER_PRDCT_DIM.MRKT_LVL_PRDCT_NM IN @PROMPT(‘Enter Market(s): ‘,’A’,’Market\Market Name’,multi,constrained,persistent))

3 sap.png

4 sap.png

Step 1:-

Create the List of values in the data foundation layer for object which was referring into prompt (Cust Align (static lov), Market Name (custom sql) & Sales force code (custom sql))

Static lOV for Cust Align

5 sap.png

6 sap.png

7 sap.png

8 sap.png

Step 2:- Custom Sql based LOV for Market Name & Sales force code

9 sap.png

10 sap.png

Step 3:- Create the parameter in the data foundation layer and point the newly created LOV values

11 sap.png

12 sap.png

Step4:- Above mentioned prompt filter need to be replaced by the parameters

Before changes

  1. ADMIN.V_DWH_ALL_GEOGR_ORG_CUST_ALIGN_REL.CUST_ALL_ALGN_TYP=@Prompt(‘Enter Customer Alignment Type:’,’A’,{‘CURRENT CUSTOMER ALIGNMENT’,’CALL PLAN ALIGNMENT’,’TARGET UNIVERSE CALL PLAN ALIGNMENT’,’CUSTOMER TERRITORY SEGMENT ALIGNMENT’,’CUSTOMER TERRITORY PRODUCT SEGMENT ALIGNMENT’},MONO,CONSTRAINED,PERSISTENT) )

After Changes:- @Prompt(parameter)

  1. ADMIN.V_DWH_ALL_GEOGR_ORG_CUST_ALIGN_REL.CUST_ALL_ALGN_TYP=@Prompt(Cust_align)

13 sap.png

15 sap.png14 sap.png

Step5:- Apply the same change for all the associated join (prompt filter) and publish the business layer after save the data foundation layer.

16 sap.png

Step 6:- Generate the sample report and verify the report data.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply