I created a Portfolio Plan on my 'Workspace Strategic Planning' and added Plan start date (start_date), Plan end date (end_date), Owner (owner), and Portfolio Plan entities (lens_entities). The entities are just a list of portfolios.
I believe this data is stored in the table sn_align_ws_portfolio_plan.
On that table, the start date, end date and owner field are readable however the lens_entities field displays a 'sysid' (example: d3bae73edbcf8b00563cff461d961966) instead of a string (example: Acquisitions).
How can I make the lens_entities be displayed as a string instead of a sysid? I need to create a readable report using that table.
Thanks!
