What is that extra column of 'AB.gAAAA=' values when I run a report model query?

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Rob — Tue, 07 Aug 2012 22:29:40 GMT

What happened to Bob Meyers?

It seems as though there are a few of us who believe that an end user tool should not expose users to computer generated spaghetti which would just confuse them. Bob, if there's no answer for this then don't be embarrassed to say so. We've been working with MSFT products for long enough now to know that they're not perfect.

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Saru — Thu, 07 Apr 2011 10:00:16 GMT

I could remove the entity key column by settings the property 'Discourage Grouping' to false at the attribute level. But not able to do the samea t role level. So for an entity which is related to another entity, once i select the attributes of the related entity, the key column appers again. Anybody got any clue how to fix that?

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

box1 — Wed, 19 Jan 2011 17:28:08 GMT

what if your models are only used to create simple table detail reports. Our users never use report builder for grouping and summarizing data. This new release 3.0 really makes it difficult to create a simple table with the wizard (the wizard is convenient when you have 30 fields to show). The wizard directs you into a matrix/tablix layout, but doesn't provide the same guidance for a simple table. RB 3.0 release is very confusing to the users with this extra column appearing from draggin an Entity to the report. If we don't need to design a report with Clickthrough links you are stuck with "garbage" data that comes out of the Entity fields.

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Brannon — Mon, 11 Oct 2010 21:06:33 GMT

If you drill down to the lowest level of the entity there will be a "<field> code" and a "<field> name". The code is the entity key value and the name is the field value. I think this is the way it works.

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Erin — Wed, 09 Jun 2010 15:23:42 GMT

I am in same boat and need help really urgent, someone help please,,,,,,,

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Exigy — Mon, 10 Aug 2009 14:19:39 GMT

Hi,

Im having the same issue. For user simplicity we would like this column not to be auto-generated, or at least not shown.

Is there a solution for this please?

re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

idybil — Tue, 10 Mar 2009 16:22:57 GMT

Hello Bob's, thanks for this anwser, I finally know why the extra column appears.

But, is it possible to hide it by some kind of settings in the report model or report builder ?

Because report builder at our place is used by end-users and a lot of them are very confused about it, they don't pick the right column, execute the report and found the "Ab.gaaa="

Thanks