I don't think it's possible in OTBI.

Thanks Vipusha

Hi Abhishek, Could you try applying the same filter using selection steps, instead of doing it using a FILTER. The selection step filters are applied right at the end, so it would do so after the RCOUNT is correctly calculated. I will try to replicate from my end and let you know.

Hi @231094, Please try below - TopN("Base"."Base Equivalent Period Net Activity" ,5 BY "<Balancing segment column name>"). This should give you something like below -

Hi Abhishek, Have you removed the column which was causing Person Number to repeat?

Use below formulae for the sequence - RCOUNT("- General Information"."Invoice ID" BY "- General Information"."Invoice ID"). You will get result as below Please accept the answer if this helps resolve your query.

Hi @Abhishek Bagh , You can try below formulae - MAX(RCOUNT(<"Folder"."Column"> BY <"Folder"."Column">) BY <"Folder"."Column">) However, the value for this count column will also repeat, as below. I have used the column "Invoice ID" for my test(in place of Person Number) - MAX(RCOUNT("- General Information"."Invoice ID" BY…

None of these tables are present in the latest OTBI lineage sheet.

Hi Anshul, I do not believe any of these tables are exposed through a PVO. You may have to go through the BIP report route(invoked from ODI) if you require data from these tables. Certain attributes of the table PO_HEADERS_ARCHIVE_ALL is exposed through the VO FscmTopModelAM.PrcPoPublicViewAM.PurchasingDocumentVersionPVO.…

Hi @vjsalve The security in the role restricts the data in the fact. To enforce the same restrictions in the prompts created using dimensions, refer to the fact through a metric. This can be done with the help of a logical sql which uses selects both the dimension column(ledger in your case), and, a column from the…

Hi, For Data Access set information related to GL, you can use the below tables - GL_ACCESS_SET_LEDGERS GL_ACCESS_SETS GL_ACCESS_SET_ASSIGNMENTS

Hi Ajay, Please share the xml for the report you have built. Also, try applying MAX function on the Company Level. It will then return the latest level, and, result in a single row.

Apologies, just read your query again, and i see you mentioned you want to click on colleague name and open a new report. Are you looking for navigation from one report to a another? Or, to filter the data in the report?

Hi, If you are looking to filter the data in the report, using a column create a dashboard prompt as Jahnavi suggested. Click on Create => Dashboard Prompt => and select the appropriate SA. Then create a dashboard and place both the dashboard prompt and report on it.

Hi Abhishek, Could check the attached report. There is a field called "Manager"."Manager Flag", which indicates whether a person is a manager or not. This is from the Workforce Management - Worker Assignment Real Time subject area. EmpMgr.zip The attachment contains the xml of a report i created. Please create a report…

Hi Swapnil, You are right, data counts will differ for different users if the roles assigned are different. Data access sets also is another reason why counts may differ. For Payables related subject areas, the data for different users may be restricted by business units(assigned to the different users). You will be able…

Hi Ajay, Have you checked the subject area - "Workforce Performance - Performance Document Status Real Time"?

Hi Dawn, Could you please share the xml of the report you tried building?

Hi Abhishek, Please try creating a report using the attached xml, and, see if it fits your need. There is a flag called - "Manager"."Manager Flag" which gives Yes/No values as below - EmpMgr.zip

Hi Ajay, Create new analysis, from any subject area. Then go to the Advanced tab, copy paste the xml into the section on top, then click on Apply XML. You can then save and go to the results tab to view data.