Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Analysis- Involving Union - Result Column - Calculated Formula

Received Response
1215
Views
14
Comments
2»

Answers

  • Cameron Loepker
    Cameron Loepker Rank 4 - Community Specialist

    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
    Cameron Loepker Rank 4 - Community Specialist

    @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":

    Union Result Column Order.PNG

    On the analysis when run:

    Union Result Column Order 2.PNG

    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:

    Drop Down.PNG

    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
    Jerry Casey Rank 6 - Analytics Lead

    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
    Cameron Loepker Rank 4 - Community Specialist

    Got it fixed up!

    thanks for your help!