OBIEE Analysis- Involving Union - Result Column - Calculated Formula

Cameron Loepker

Jerry,

Thank you for your help. I believe I am now past getting errors and am getting the data. now on to getting these filters to work correctly so I actually have different dollar amounts per their respective codes .

thanks,

Cameron

Cameron Loepker

@Jerry Casey,

One more question for you, I am having an issue when it comes to ordering the columns:

In the Parent level "Result Columns":

On the analysis when run:

For some reason OBIEE doesn't want to make it easy for me to reorder these columns. I figured it should be easy enough to right click and move column, but all the options available are to send the column to another section:

So in the criteria tab, the "result columns" are not in that order, and on the results tab i am getting above mentioned drop down with limited options...

ideas?

Thanks,

Cameron

Jerry Casey

Hi Cameron,

In the Criteria tab, when you hover your cursor over the header, do you not see a 4-way arrow?  When you do, you can click-and-drag the header into the correct position.

That's what I was referring to above, about the header for your added column.  You have to do that to get the header for an added column (in the query body) into the correct position in the union, inside any "results" columns in the header line.

Beyond that, dragging columns around in a union is a minefield, because the correct column-header relationships have to be maintained across all legs of the union.

The "saw_x" columns can be moved around among themselves, because all saw_ references are pointed into the body of the query.

The column order in your results is set in whatever view you are using, (table, pivot table, etc.), independently from their position in the Criteria window.  You should be able to go into your results and put the columns in any order you want.

Cameron Loepker

Got it fixed up!

thanks for your help!