search cancel

Custom TSV in dev (RCS-6319)

book

Article ID: 227794

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Steps To Reproduce:
1. Create Project Subobject
2. Create attribute
3. Create a time-varying attribute

Configure > List Column Section > New
Click Add > Display Type = Time Scaled Value
-Add the value attribute, give it a Label,
Number of Periods,
checkmark Show Legend Column, Show Column Label
-Save and Allow Grid Editing

4. Review Project > Subproject page

5. Enter data.

Actual: Custom Time Scaled Value Attribute values are not shown for data values with null or 0.
Expected:  Custom Time Scaled Value Attribute values to be shown for data values with null or 0 using the following query:

select prj_object_id, slice, to_char(slice_date, 'yy-MON') AS units,
nvl(slice,0.0)
from ODF_SL_5xxxxxx
order by 3,1



Resolution

The following basis query can be used to convert to NSQL:

select
nvl(null,b.prj_object_id),
CASE WHEN
   b.slice is null
   THEN 0.0
   ELSE b.slice
END,
a.time_key,
a.period_start_date
from
nbi_dim_calendar_time a
full outer join ODF_SL_5XXXXXX b
on to_char(b.slice_date, 'YYYY-MM') = a.time_key
where a.hierarchy_level = 'MONTH'
and a.period_start_date between '01-JAN-2021' and '31-DEC-2021'
order by 1, a.time_key