Skip to Content

Two records after adding Proj type

Hi,

I have an below webi output based on two sources. SAP and Oracle

Case 1 output:

ordnum(merged dimen of SAP and Ora) plant (merged dimen) profictr (merged dimen) Amt1 Amt2 Am1-Amt2

342 XXXX 792 238482 200 238282

Case 2 Issue: Adding Proj type into the Case 1 output

ordnum(merged dimen of SAP and Ora) plant (merged dimen) profictr (merged dimen) Amt1 Amt2 Am1-Amt2 Proj type

342 XXXX 792 200 200 Projects

342 XXXX 792 238482 238482 Project

From Case 2 output, i just added proj type dimension into case 1 and the amount is splitted up into two records.

Now what iam trying is endoutput should be case 2 should have one records only as like case 1 having Proj type as additional column. Both Projects and project is of type Projects proj type.

Appreciate your help.

Thanks,

Dinya.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 20, 2015 at 06:27 PM

    HI

    can you share webi output screenshot.it's difficult to understand the data which you have mentioned.

    if project type has two values and you will drag into the table then records will split.

    even in the case1 if you will drag the project type with multiple values the records split.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      try like this.

      V ProjType=if([projkey]="periodic") or ([projkey]="periodic ct") then"PSR" elseif([projkey]="Project Ord") or ([projkey]="Projects") or ([projkey]="SC Projects") then "PS1" elseif([projkey]="Std Ord") or ([projkey]="WNS Ord") then"POR"

      Amit