Variable

building reports desktopintelligence
1

HI,

I have created a variable as given below. Variable is used across more dataprovider so dataprovider name is displayed next to the variable.

Test
= If Var(DataproviderName) =“ABC” Then “” Else Var(DataproviderName)

If i include this in the report. i have no errors i could see the text in the report.

But If i run the report, the (dataprovider name) is automatically removed in the variable. So this Variable not parsed.

Hence iam getting an SYNTAX error.

Any Suggestions are welcome.

G

AvadiZone :india: (BOB member since 2008-04-19)

2

What are you trying to do actually using Var function with Data provider? Explain your requirement. Because Var is a function to calculate variance taking number as input and not a string.

Jansi :india: (BOB member since 2008-05-12)

3

Thanks for the response!

Sorry for the mess up. It is not Var function and it is variable name

I have created a variable Test
For Eg

Test = If DimensionName(DataproviderName) =“ABC” Then “” Else DimensionName(DataproviderName)

Dimension is used in more dataprovider.

When i include this Test Varible in the report. I don’t get any syntax error. But when i refresh the report i get syntax error and If i see the variable test syntax, dataprovider name of dimension is automatically removed.
Which causes the problem…

Hope this is somewhat clear

Cheers,
G

AvadiZone :india: (BOB member since 2008-04-19)

4

Hi

V_Test= If A (query1 with ABC)=0 then ‘xxx’

This is what your trying to do in your report…? If so, i think that your data provider name is different from the DP name you have given when created the report…please check it once…

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

5

Thanks!

You are right!

But I tried creating a new variable Now and ran the report. Still i face the same Issue

Cheers,
G

AvadiZone :india: (BOB member since 2008-04-19)

6

Hi

Its better to copy your dataprovider name and paste it when your creating the variable… the object with the dataprovider name will come only if you have multiple dataprovider and both the data provider having the same object name…

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

7

HI,

Ya i agree and also know that the object with the dataprovider name will come only if you have multiple dataprovider and both the data provider having the same object name…

I tried one more thing: i used the Universe Dim Object directly in report. and when i refresh it i don’t find any error.

When tried using the same Universe Dim Object inside the report variable. and If i refresh the report then it causes the syntax error.

if i see the syntax of the report variable i could the syntax changed from Variable(Query1 with DP) to Variable. After Refresh syntax changes automatically

Iam not sure what is happening!

AvadiZone :india: (BOB member since 2008-04-19)

8

Hi

Could you post your report if possible…? if not, try a same type of report with efashion and if you the problem exist, send us the report designed with efashion…

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

9

Could you send your email to mail the report.

AvadiZone :india: (BOB member since 2008-04-19)

10

Do you mean this? =DataProvider()

Jansi :india: (BOB member since 2008-05-12)

11

Hi,

My problem is like this issue, Which has been discussed in the forum

But I couldnot find a solution.

AvadiZone :india: (BOB member since 2008-04-19)

12

Yes, I don’t know what is happening there. Because I face no problem here with this code.

=If (<Country(DP1)>="US")Then "" Else <Country(DP1)>

Jansi :india: (BOB member since 2008-05-12)

13

I can…but its better to share the report among us…it will helps you to get a speedy feedback…

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)