Right Values, Wrong Captions

[kimmal]

Hi,

Not sure if this is the right place to post this, as I'm seeing these results in AS and RS.  I have a report that shows sales by Day of Week.  Results look something like this:

Monday = 2118
Thursday = 2204
Friday = 3066
Saturday = 2106
Friday = 1439
Saturday = 1538
Sunday = 2053

When I run a SQL report against the source tables, I'm getting

Monday = 2118
Tuesday = 2204
Wednesday = 3066
Thursday = 2106
Friday = 1439
Saturday = 1538
Sunday = 2053

As you can see, the AS and RS reports are showing the right values, but the caption for the days is wrong.

Thoughts?  Is this an issue with the fact that I have not set any determinants?

[bdbits]

In Report Studio, choose menu item Tools > Show Generated SQL/MDX.

Compare the two sets of SQL to see where they are different. This may give you a hint to the root cause of the different outputs.

[MFGF]

Hi,

Not sure if this is the right place to post this, as I'm seeing these results in AS and RS.  I have a report that shows sales by Day of Week.  Results look something like this:

Monday = 2118
Thursday = 2204
Friday = 3066
Saturday = 2106
Friday = 1439
Saturday = 1538
Sunday = 2053

When I run a SQL report against the source tables, I'm getting

Monday = 2118
Tuesday = 2204
Wednesday = 3066
Thursday = 2106
Friday = 1439
Saturday = 1538
Sunday = 2053

As you can see, the AS and RS reports are showing the right values, but the caption for the days is wrong.

Thoughts?  Is this an issue with the fact that I have not set any determinants?

Hi,

How is the attribute for MemberCaption defined in your model? I assume it's DMR? In fact, what is the ID of that level too?

MF.

[kimmal]

Not 100% clear what you mean by how is it defined.  DMR yes.  I've attached a pic of the dimension definition and in the left bottom corner of the pic you can see the results when I click test.  The test is showing the proper Member Caption against the business key.

Furthermore, I've created a package just off of the query subjects, not a DMR package, and the data returns properly, that is I have the proper Weekday names when I query the new package with query studio.