Skip to Content

"DataProvider" formula error in the WebI report footer

Hi All,

Data Provider formula used in the object 'Name of Dataprovider' retrieves different values in QA and PRD environments .

The formula within the variables is 'Name of Data provider'= DataProvider([Articles réservés].[Work Order]) and it's qualification is detail.

It seems that it retrieves also the universe name in PRD environment.

This result causes the error in other variables. For example, the universe name formula doesn't work fine because the name of the query doesn't exist.

Kindly check the below image and provide your solution over my concern .

Please let me know , Is there any mistake happened in writing the formula or connection/DB Issue ?

Thanks

Ram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 08, 2016 at 06:11 PM

    Hi,

    Seems like Universe name is not displaying in QA. Did you tried UniverseName() function?.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jyothi,


      Actually issue is ,user had mentioned the variable 'Name of Data provider'= DataProvider([Articles réservés].[Work Order]) and this formula has to show [Articles réservés].[Work Order].


      But in QA ,it is showing only Articles reserves where as in Prod , it is showing Articles reserves with universe name.
      In both the systems ,formula is giving wrong results .


      Kindly let me know , Do we need to change the other formula to get Articled reserves with Work order in webI report footer?

  • Nov 09, 2016 at 04:29 PM

    Hi,

    Does the user want to display the name of the object on the report?,

    DataProvider([Object Name]) will display the Metadata connection name.

    Check the cell format or the connection in QA-WebI report.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jyothi,

      Please read the below info thoroughly.

      ~~one thing , what will happen If we use variable - data provider([Article Reserve].[work order])...... what's the output ?

      ""Fyi, We are not using this variable in table , we are just dragging the variable into report panel""

      ~~For your query ,the solution is They want to use this variable object in webi report footer.

      ~~Also, In dev and qa the output for the formula is below

      ("Name of data provider

      Article Reserves") i.e., when we drag that variable into report panel.

      ~~ But when we drag this variable into report panel in Prod system it is showing as below

      (Name of data provider

      Article Reserves. Universe name).

      Please do the needful on how to avoid Universe name in Prod system.

  • Nov 10, 2016 at 08:02 PM

    your dev and prod envirnemts are same BO version?

    I have tested with BI 4.1 SP08 and dataprovider() function gives the data-providername and universe name.

    If this is urgent then you can use below formula to exlude universe name from this.same time you can rasie the support ticket to get the anwer.

    =Substr(DataProvider([Your objec]);1;Pos(DataProvider([Your object]);"-")-2)

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 14, 2016 at 05:48 PM

    Hi,

    How did the migration of the report and universe from QA to prod?. check the history in QA and prod of the connection and universe selection while doing migration.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded