Command Table - Business View Manager

[former_member289873]

Greetings,

I'm trying to create a command table, in Business View Manager, that is a view of the FACTS table.

Command Table:

Time_ID

Measure_ID

Valuetype_ID

Amount

I want to sum all duplicate fields by amount, so I try to create a command table with the following code:

select dbo.facts.Time_ID, dbo.facts.measure_ID, dbo.facts.valuetype_ID, sum(dbo.facts.sum)

From dbo.facts

group by facts.Time_ID

and I get the error "SQL syntax error returned. Please modify ant try again"

But, if I isolate de expression without the field sum(...) or only with the sum field it returns the result.

Can anyone help me?

Thanks.

[former_member289873]

Solved,

I have to put all fields except the amount field in the group by expression 😃

Thanks