I have a BQ-query which has run fine for some months now. Since a few days some columns seem to have doubled. I mean that 3 of my 10 columns are double in excel, and now I have 13 columns, instead of 10.
I use BQ 5.1.8
pehuyghe 
(BOB member since 2004-05-18)
When you click the SQL button in the Query Panel, do you actually see code for 13 columns in the SELECT portion?
KSG 
(BOB member since 2002-07-17)
I found it. I’m querying 2 fact tables, with one of the dimensions only being selected with the second fact. Apparantly BQ splits the columns in 2 parts then: one for my first fact, and one for the second. If I delete the one dimension in my query everything turns to normal.
in my query panel I have this :
dim1, dim2, dim3, dim4, fact1, fact2
in excel I get this :
dim1, dim2, dim3, dim4, fact1, dim1, dim2, dim3, fact2
when I purge the dim4 object I get this in Excel :
dim1, dim2, dim3, fact1, fact2
I guess this is normal behaviour. Is it ?
pehuyghe (BOB member since 2004-05-18)
I think it depends on the Universe settings. Look in Designer, the Parameters, the SQL tab, at your “multiple paths” settings.
KSG (BOB member since 2002-07-17)