Good afternoon
I need help setting up a cube and a report via sql.
There is this request:
SELECT bdcn.body, cnt.creator, usm.lower_username, cnt.creationdate, cwd.display_name, cnt.contentid
FROM BODYCONTENT bdcn,content cnt, user_mapping usm, cwd_user cwd
where bdcn.contentid = cnt.contentid
and cnt.creator = usm.user_key
and usm.lower_username = cwd.lower_user_name
and bdcn.CONTENTID IN (
SELECT CONTENTID
FROM CONTENT
WHERE CONTENTTYPE = ‘COMMENT’)
ORDER BY cnt.creationdate DESC
It displays the full name of who wrote the comment, the date of the comment, and the comment itself.
I need to make a report that will include the user’s full name in the Rows field. The measure of the comment depends on it, and measures contained the date of the comment.
In general, the idea of the report is to display a list of users with the date of the comment and the comment itself, but at the same time so that the user is not duplicated in other comments.
I read the instructions, it is not clear to me, there is no exact data and what it looks like.
Please help me send me screenshots of how and what to put where.