STEPS TO REPRODUCE
1. Create an Nsql query using the following;
SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:A123:
[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:AAAA:
[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:BBBB:
[email protected],
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:CCC:
[email protected]FROM
(
Select
12345 as A123,
(2) as AAAA,
to_CHAR(-2) as BBBB,
-1 as CCC
From Dual
)SQL
where
@
[email protected]2. Create a Grid portlet using the Query created in step 1 as the data provider and add all columns in the List Column layout section
3. Put the Portlet in a Tab on PPM => Home => Overview page and do an Export to Excel (Data Only)
EXPECTED:
Data gets exported to Excel and file opens up successfully
ACTUAL:
Excel file generated errors with message - 'This file cannot be opened because of errors'