Data between QA and Prod

building reports desktopintelligence
1

Hi All,

I am experiencing a little bit strange issue here.
I have a table which I created in QA Environment Deski and the table has few columns which has report level variable and Universe objects.

The QA table has sample data as the attached one. (1.jpg)

When I logged in to Prod Deski and I open this report and refreshed then the data for RiverSource appears,but in the place of the name it becomes empty. Please see the attached sample (2.jpg)
There is a Break on the name column
Does anyone encountered this type of similar issue before and if you have any solution to this, please let me know
Thanks…
2.JPG
1.JPG

JohnJustus :us: (BOB member since 2007-06-25)

2

Hi All,

An update - My assumption was little wrong. The Pic1 has no relationship with pic2.jpg.

In the pic2.jpg the name is empty in the database for sales but there are measure values like 11 and 10.
How this data issue can be addressed?
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

3

That’s going to be more difficult to trouble shoot when there is different data in your QA and Prod environments. Does this have more than one data provider? Did they both get reassociated to the Production environment? Did they both refresh properly? etc.

digpen :us: (BOB member since 2002-08-15)

4

Just a single data provider.
The data may not be upto date between QA and Prod so there may be difference in numbers between QA and Prod.

The key issue here is , though it is not my issue, if you see the Pic2.jpg for sales tier there are score data like 11 and 10 but there is no Tradingname associated with it. I believe this is an data qualtiy issue and want some information on how to address this. Even in QA also the issue has.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

5

In addition to that I am trying to filter, if the Trading name is Null using the below formula,

=If Not(IsNull(<Trading Name>)) Then <Trading Name>

But it doesnt work. Also, I tried flag as below that also not getting applied to the table

=If Not(IsNull(<Trading Name>)) Then "Y"

Also, I tried applying in the Query level like TradingName Is not null and it doesnt work. What would be the issue or Is my formula in the report level wrong?

Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

6

An update - When I used TradingName ID then the filter works as I expected.

JohnJustus :us: (BOB member since 2007-06-25)

7

It’s quite possible that they are not completely blank and have a space or other character present. Have you looked at the raw data provider or tried wrapping the text in quotes as a quick check?

digpen :us: (BOB member since 2002-08-15)

8

When I checked the raw data in the dataprovider for the Tradingname ID it shows as #empty and the Tradingname is blank
Can you let me know how can I wrap the text and double check? I did not understand that.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

9 
="*" &amp; <texttoverify> &amp; "*"

digpen :us: (BOB member since 2002-08-15)

10

Thanks.
In the Tradingname column I used ="" & & ""
and for the blank it displays as * *, that means they are really blank and this issue has to be addressed on the data side.

Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

11

Was that: ** or * * ?

The latter has a space between the two characters.

digpen :us: (BOB member since 2002-08-15)

12

Hi,
It was * * space between 2 characters.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)