Report failing for .unx

[sachin_v_joshi]

Current BO Env: BO4.1SP3

We have a universe which was in BO XI3.1 now migrated to BO4.1SP3

Issue is that a report which references this universe is failing as it is unable to parse derived tables (around 10-15).

We had a look at the universe file and could be opened through IDT.On checking the derived table syntax, all seems correct bt at report it is failing.

We tried repointing the same universe file by changing the data source[Modify mode] but it did not help as this file saved under ABC_XYZ.unx

i tried searching if similar issue was faced by any one but this is unique...

Can you suggest to correct the report ?

[former_member210032]

joshi

are you put your derived table into business layer or not

Regards

Mustafa

[sachin_v_joshi]

Yes it is already present.

[former_member210032]

HI joshi,

check your syntax of the derived table and check the join weather it is inner or outer join and match with your 3.x universe.

Regards

Mustafa

[sachin_v_joshi]

Osman,

All the queries that are in the derived tables are syntax wise correct. There is no issue with them

I have clearly mentioned that this universe is in unx format for which derived table cannot be referenced through launch pad.

Also, we are on SAP BO4.1 SP3 and not on 3.x.. I'm awaiting for your further response

[sachin_v_joshi]

Is this a bug in SAP BO4.3 release of IDT?