Sum by two Groups

Andrea Portes

I am working in a subject area where I need to sum data for each person by a group of identified data within another group of identified data. right now I have the sum working by person, but it is creating a separate row per data type. I want all data types in separate columns to appear on a single row.

Right now I have:

sum(cast(case when ("Payroll - Element Entries Real Time"."Input Value"."Input Value Name" in ('Percentage') AND "Payroll - Element Entries Real Time"."Element"."Element Name" in ('RSP')) AND "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" IS NOT NULL then "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" END AS Numeric) by "Payroll - Element Entries Real Time"."Element"."Element Name")

Where "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" is a type of "Payroll - Element Entries Real Time"."Element"."Element Name" and I am summing "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value". All this is CAST bc "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" is a text field. right now all is working execpt that I have a different column for each combination of type of "Payroll - Element Entries Real Time"."Element"."Element Name" and "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" that is being used. Right now, even though they are in their own columns they are still creating separate rows.

[Deleted User]

Is this in OTBI or OBIA? Do you have access to the RPD? Because it's the modelization in the RPD which defines granularity and it definitely sounds like you have a granularity issue with forced query grains.