Search code examples
export-to-excelcopy-pastebusiness-intelligenceobiee

OBIEE 12.2.1.2 COPY data from dashboard - PASTE in excel: wrong order


when copy pasting data from dashboards (pivot tables; no interactions), sometimes the order in excel is wrong:

I.e.: Dashboard: I have marked a - b ( 1 2 4 5) of a pivot table from left to right and copied them. enter image description here

Pasting them into Excel sometimes results in:

enter image description here

Marking C B A (from right to left) and pasting into excel would sometimes result in:

enter image description here

Using the regular obiee export button works fine (always).

Ideas and suggestions are much appreciated - this happens with all browsers.


Solution

  • That is so not what you are supposed to do anyways it's not funny anymore. Copy+paste into Excel? Pray tell me why you try to use an analytical system in the first place.

    tl;dr : Totally wrong usage of the tool.

    Edit: By the way in 11g you couldn't even copy the data that way for security reasons because it's an action that isn't logged anywhere.