Skip to Content
-1

Problem whille fetching data with derived fields and table fields in HANA and in AO report

Feb 13 at 06:02 AM

18

avatar image
Former Member

I have created a Graphical Calculation view with table fields and derived fields. I am getting output perfectly. When i am generating a AO report, while fetching the data with derived fields the count is same. But when I am fetching the data with only table Fields, count is not same.

Ex: Table fields are DOCID,ROLEID and ROLE GROUP, Touches_No

Derived fields are WorkFlow Start Date and Time, WorkFlow End Date and Time.

In AO report, in selection screen i am giving DOCID. immediately it showing me Touches_No as 37(Actually its 80).

when I am fetching with WorkFlow Start Date and Time, WorkFlow End Date and Time, I am getting actual count Touches_No as 80 and giving me all the ROLEID's, ROLE GROUP's.

But when I am fetching with only DOCID, ROLEID and ROLE GROUP, its giving me 37 only and very few ROLE ID's and ROLE GROUP's.

is there any particular reason behind this? HANA supports column based tables, is there any impact while fetching data with table fields and derived fields .

could anyone please help on this

Thanks in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 15 at 09:15 AM
0

Hi,

My issue resolved and here is the solution.

While fetching data , its aggregating the data on Date. it has similar dates.

i have taken Timestamp field also for output. Finally it aggregates data with time stamp and all the records are coming perfectly.

Share
10 |10000 characters needed characters left characters exceeded