Unx Universe Issue in BO 4

[former_member214236]

                                                '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.

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

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))

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

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

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

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)

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

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