660961 - Socorro - add 'channel' to 'reports'; create new productdims w/channel

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[K Lars Lohn [:lars] [:klohn]]

as the way of uniquely identifying products/versions we need to add 'channel'.  The value already comes in with the raw json.

Comment 1

[K Lars Lohn [:lars] [:klohn]]

the 'Nightly', 'Aurora' and 'Beta' channels will use a different TCBS aggregation scheme.  The TCBS table for these channels will reference a product dims table that includes 'channel'.  Create this table.

What ramifications does that have on the existing product dims table?  It is currently our only way to get 'branch' and the 'branches' view is based on the existing 'productdims' table.  Will the new 'productdims with channel' also need to have branch information?

It is my goal to have both productdims tables populated by the processor.  Is this a good idea or is the current method better?  What is the current method?

Comment 2

[Robert Kaiser]

(In reply to comment #1)
> What ramifications does that have on the existing product dims table?  It is
> currently our only way to get 'branch' and the 'branches' view is based on
> the existing 'productdims' table.  Will the new 'productdims with channel'
> also need to have branch information?

What is the "branches" view? I actually was never really sure what we really need the "branch" for...

Comment 3

[Aakash Desai [:aakashd]]

Hey Robert and Lars, there seems to be a bit of confusion here on requirements for the bug. Is there something I can help with?

Comment 4

[Robert Kaiser]

Comment #0 seems to be pretty clear and understandable for me.

I don't really understand comment #1, so only Lars can comment on that.

Comment 5

[[:jberkus] Josh Berkus]

This was implemented ages ago when we deployed 2.2.  Not sure why this bug is still open.