Skip to Content

Isolated table Error

Hi,

Could you please help me to root cause the problem of the error in we bi report as iam experiencing this for the first. Looks like me its a database error

I have two data provider with one as delhi class and other as mumbai class belong to same universe but no joins at the design as it is isolated table.

I want to merge prompts and webi common dimension for my reqd of the report .

Thanks,

Dinya

Capture.JPG (17.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 20, 2015 at 03:20 PM
    10

    Hi,

    have you done some customization in the webi query SQL? reverify if you have by mistake added some objects from delhi class to mumbai query or vice-versa?

    or first try to run individual query in webi and see if it's working or not.

    Share your webi report SQL.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Why this coming then in webi report?

      "Year" INTEGER, "Month" INTEGER, "FiscalMonth" TIMESTAMP, "Action" VARCHAR (50), "OrdNo" VARCHAR (30), "Ord" VARCHAR (30), "Description" VARCHAR (100), "LOB" VARCHAR (3), "BusUnit" VARCHAR (3), "tot1" DECIMAL (19, 4), "C_Total" DECIMAL (19, 4), "CustomerOrderNo" VARCHAR (30), "JobType" VARCHAR (3), "HFMCode" VARCHAR (100), "CodeCode" VARCHAR (3), "BKDate" TIMESTAMP, "OrderType" VARCHAR (30), "DataSourceName" VARCHAR (100)

      )

      SELECT

        Table__14."Ord",

        sum(Table__14."tot1")

      FROM

        "DT_Mumbai"  Table__14

      WHERE

        concat(( ifelse(length(convert(Table__14."Month",Varchar))=1,

      concat('00',convert(Table__14."Month",Varchar)),

      concat('0',convert(Table__14."Month",Varchar))) ),( concat('.',convert(Table__14."Year",varchar)) ))  =  @Prompt('Fiscal Year/Period (Selection Options)','A','Test Connection\Dt Mumbai\Fiscal Year/Period (Selection Options)',Mono,Free,Persistent,,User:0) AND

      GROUP BY

        1