Skip to Content
0

Missing GROUP BY on IDT

Jan 16, 2017 at 01:30 PM

43

avatar image

Hi guys,


I have noticed the following strange situation when using a UNX universe created on IDT.

I have 2 dimensions (A, B)and 1 fact. The fact is defined using a function (COUNT). When combining the fact with the first dimension (A) (a normal table column) the query is generated properly adding the GROUP BY clause as expected.
Code:SELECT
ChangeRequest.RequestStatus,
COUNT(ChangeRequest.Id)
FROM
F4E_BCMP.dbo.ChangeRequests ChangeRequest
WHERE
( ChangeRequest.Deleted=0 )
GROUP BY
ChangeRequest.RequestStatus


But if the query includes the dimension B and the fact the GROUP BY is not included. Code:SELECT
CONVERT(date,BaselineManagerImplementation,103),
COUNT(ChangeRequest.Id)
FROM
F4E_BCMP.dbo.ChangeRequests ChangeRequest
WHERE
( ChangeRequest.Deleted=0 )

I have tested that problems seems to come from the definition of the column B. In particular the use of the CONVERT function in the dimension definition.

My question is: Is this a limitation of the BO engine? A bug?

Has someone noticed this behaviour?
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 16, 2017 at 01:37 PM
0

what is your BO version?

is object B is parsed in IDT?

Share
10 |10000 characters needed characters left characters exceeded