Current Position:Home > Adding new column in an existing report which was build using Union

Adding new column in an existing report which was build using Union

Update:10-11Source: network consolidation
Advertisement
While working in OBIEE 11g I encounter an issue.
My existing report was build using UNION at Criteria Tab in Analysis. Now I have a requirement to add a new column into the same report. For each criteria I have added the new column but when I go back to the "Result Columns". I see a new field added but it is not allowing me to open or edit column properties for that new column & at the same time it is not allowing me to navigate to other tabs like Results, Promts, and Advanced.
I don’t want to build this report from scratch. Is there any workaround to get it resolved?

The Best Answer

Advertisement
Hi,
Just check it once the new added column data types are mismatched or not?
and the new added column should be navigated into excluded section, so u should edit the report and dragged into the table column section.
Thanks..
  • Adding new column in an existing report which was build using Union Update:10-11

    While working in OBIEE 11g I encounter an issue. My existing report was build using UNION at Criteria Tab in Analysis. Now I have a requirement to add a new column into the same report. For each criteria I have added the new column but when I go back

  • Adding the columns dynamically in crystal report Update:11-30

    Hi,   I am developing a application using asp.net and crystal report. In a report the column is created dynamically( ie, the report gets input from a sp which returns N no. of columns). Since i dont know the column name and no. of columns at design t

  • SSIS 2005 Adding a Column to an existing Package Update:11-30

    Hello Forum forgive me but it 's been over 5 years since I touched SSIS. We have an SSIS package that compiles data and then exports the data to a MS Ecxel Spreadsheet.  We are struggling to add an existing column. Essentially the package reads data

  • Found errors in existing report after added a column in an existing table Update:11-30

    Hi, I have a Table called "EMP" and a interactive report "EMP_Details". EMP table has data and it shows in the report. EMP_Details report has two buttons. - 1.Create - it is used while inserting a new record into the table for a new jo

  • Column Widths of existing Report Update:11-30

    Hi, I'm wondering how you can modify the width of a particular column in a report. One of the columns has a lot of information, and I want this column to take up about half the page. I look in the Application Builder to see the properties of that col

  • How to add a column to an existing report Update:11-30

    Hi, I have a report which I need to modify (add a date column). I included the date in the query but it doesnt show up when I run the report. Where else do I have to make changes and how? I need some help. Thank you all so very much. A/AHi, mhh, how

  • Problem adding column in an interactive report Update:10-11

    Hi all I am dealing with many interactive projects in my application. Sometimes I have to add a column to the interactive report. When I do so, the column doesn't appear in the interactive report...On the page I have to click on "Actions" then g

  • Renaming columns resulting in breakage of already existing reports Update:11-30

    Hi We recently upgraded from 10g to 11g and we faced the following issue related to trailing spaces: In 10g we had trailing spaces for few columns which accounts for say around 300 in number. After consistency check, these trailing spaces were shown

  • Problem with column groups on Interactive Report Update:10-11

    Hi I am hoping that someone can help with this problem. I am attempting to control both the grouping and ordering within each group of fields in the single row view of an interactive report. Creating column groups appears to be OK at first (sequence,

  • Column Headings in the report and adding an extra field to the report Update:11-30

    Hi All. I had an issue like i need to put column headings for a report and I want to add an extra field to the report. The problem here is that the report was actually cloned from a Query.At the time of cloning,they forgot to add the column headings.