Skip to Content
0

"DataProvider" formula error in the WebI report footer

Nov 08, 2016 at 03:29 PM

104

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Jyothirmayee A Nov 08, 2016 at 06:11 PM
0

Hi,

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

Thanks,

Jothi

Show 1 Share
10 |10000 characters needed characters left 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?

0
Jyothirmayee A Nov 09, 2016 at 04:29 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

0
AMIT KUMAR
Nov 10, 2016 at 08:02 PM
0

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)

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Awesome Amit and it really worked for me in prod.

But amit ,my query is with out this type of formula ,we got the actual result

i.e., (Name of dataprovider

Article Reserves ) in both Dev and QA.

For your query , I have checked the BO Versions and those are as shown below .

1. webi version

non prod-4.1 sp 6 patch1

prod 4.1 sp 2

2.BI launch pad

non prod and

prod - 4.1 sp6 patch1

Kindly let me know , Is there any problem with BO version Specific ?

Amit, Currently I'm working in a support project as a BO Admin and got this ticket from developer .

Is this a platform related ticket or a developer related in support project ?

Please do the needful asap.

0

Better to raise SAP support on this. According to webi functions guide help it should display Data Provider name only but this is showing universe name also.

This is might be webi product issue.

1

When I try to open the report in BI LaunchPad on the systems (Dev, QA ) and dragging the variable 'Name of dataprovider' into the report panel , it is showing as dataprovider name only.

But When I try to open the report in BI LaunchPad on the systems ( Prod ) and dragging the variable 'Name of dataprovider' into the report panel , it is showing as dataprovider name along with universe name.

My query is BO Version BI LaunchPad 4.1 SP 6 Patch1 for both Non prod and prod systems.

In this case , Do we think this issue as a webI product issue ?

0

open the variable in Dev & QA and check if static dataprovider name is mentioned there or dataprovider function is used?

Also try to create another variable with dataprovider function and see what is coming?

0

They had used dataprovider function only in all the systems as below

Dataprovider([Articles réservés].[Work Order])

0
Jyothirmayee A Nov 14, 2016 at 05:48 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded