3 Replies Latest reply: Sep 24, 2013 10:02 AM by mpolero-OC RSS

    OBIEE 11.1.1.7.1 export to excel issue

    mpolero-OC

      Hi:

        I have a problem exporting to excel when i have links to drill down in the data.

       

      1) If exporting to excel just the table. It's prompting to select Excel 2003 or Excel 2007+

             - If you choose Excel 2003 the export is fine and correct...the columns with the links ...are just that

             - If you choose Excel 2007 + the export is not fine and the columns with the links are shown the full url.

       

      e.g.:

             something that should shown a number, 49,9872, it is showing

      href=/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FBrazil%20Sales%20v2%2F_portal%2FAccount%20Receivable&Page=DSO%20por%20Cliente&Action=Navigate&col1=Channel.Channel&val1="ATACADISTA"&col2=Salesman."Customer%20Sales%20Region"&val2="REG%20CO"&col3=cast("-%20Generic%20Time"."Fiscal%20Year"%20as%20char)&val3="2013"&col4="-%20Generic%20Time"."Month%20of%20the%20Year%20Description"&val4="JULY">49,9872</a> instead

       

      2) If you choose to export the full dashboard page or the full dashboard itself ....is not letting you choose between excel 2003 or excel 2007 + ...so i assume the latter is being used since it's not exporting it right ...but with the href code as described above.

       

      Any idea about what might be going on or how to fix this issue?

       

      Thanks a lot!

      Matias