BW reporting for cFolders

[Former Member]

Hi,

Anyone has done the BW Reporting for cFolders?

We are in ECC6 with SAP cFolders 4.5.

This is what i have done in BW for cFolders, but the query part don't show anything.

- Went to RSA5 and Activate Datasources under APCO_CFOLDERS. The following datasources activated, 0AREA_ATTR , 0CFO_COLLAB, 0CFO_TRANSACTION, 0COLLABORATION_ATTR, 0FOL_ATTR.

- Went to RSA6 and Saved.

- In the Business Content (BI Content), i saw under PLM Infoarea, got some infocube, query, etc.

- So i have done that too and i can see everything in the Data Warehousing Workbench (RSA1).

Normally if we have Infocube, we create Update Rules, followed by info source in which we can assign the respective Data sources and then schedule the job to get the data inside the Info Cube.

But for the cFolders, i can't able to do the same. Is there any difference in doing it? Please give some suggestion.

Thanks

[Former Member]

hi,

i want to know what type of reports u want?

if u want how many documents uploaded per month , users , date .

what types of report u wnat to generate?

thanks

amit

[Former Member]

Hi,

Thanks for your reply.

Yes as you said i want that type of report as well status report, that is what is the status of the each drawing uploaded.

[Former Member]

hi,

if u using cfolder4.0, integration with BI is not provided.

you can do one thing

go to t code SQVI. here u can join two tables and fetch the data as mentioned in pervious reply.

the tables are as follows.

CFF_PHF and CFF_PHIO

join these two tables and what fields u want as output , u can get the result.

if any probelm in creating infoset, plz revert back

in cfolder4.5, ingegration with BI is provided.

BW Reporting on quantity structure of collaborations on cFolders server

The purposes here is to give cFolders administrators volume and cFolders usage information over time.

The Analytics provide details on number of collaborations over time, size of content etc.

thanks

amit

award points for useful answer

[Former Member]

Hi,

Yes as you said through query, we can get some basic reporting.

But i have problem doing the same in cFolders 4.5 through BI reporting. Thatz what is my question. Do you have any idea?

Anyway, i was referring these tables CFS_PROFILE_OBJS,CFS_STAT_ACTION , CFS_STATUS,

CFS_STATUS_FGRP , CFS_STATUS_PROF, CFS_STATUS_PROT , CFS_STATUS_TRANS ,

CFS_TRANS_ACTION to get the status report.

But in the above tables, there are some fields like TRANS_ID, PROFILE_ID etc which are hexadecimal or alphannumeric format. So it is not showing the physical folder name or colloboration name etc.

Do you have any idea how to get the physical name as seen in the cFolders screen?

Thanks & Regards,

Ani

[Former Member]

hi,

refer these tables

table name Description

CFF_ADD_CHKF SDOK: File name of last checkout

CFF_ADD_CHKO SDOK: Checkout data for physical information object

CFF_ADD_IDXSTA SDOK: Status Table for Indexing Documents

CFF_ADD_PHF SDOK: Files of Physical Information Objects

CFF_ADD_PHHR SDOK: Outgoing hyperlinks from physical objects

CFF_ADD_PHHRPR SDOK: Attributes of Hyperlink Relationships

CFF_ADD_PHIO SDOK: Physical information object instances

CFF_ADD_PHNM SDOK: Use of target anchors in physical objects

CFF_ADD_PHNMPR SDOK: Attributes of Target Anchor Relationships

CFF_ADD_PHPR SDOK: Attributes of Physical Information Objects

CFF_ADD_PHRE SDOK: Outgoing Links of Physical Information Objects

CFF_ADD_PHREPR SDOK: Attributes of Outgoing Relationships for PHIOs

CFF_ADD_PHRI SDOK: Physical information object incoming relationships

CFF_ADD_PHRIPR SDOK: Attributes of Incoming Relationships for PHIOs

CFF_CHKF Collaboration Folders - PHIO: Instances Physical Info: Dat

CFF_CHKO Collaboration Folders - PHIO: Instances Physical Info: Che

CFF_CONT CFF: Table for Document Content (Import/Export)

CFF_CONT_URL CFF: Table for URLs

CFF_IDXSTA Collaboration Folders - PHIO: Instances Physical Info: Sta

CFF_LOIO Collaboration Folder: Instances Logicial Information Object

CFF_LOIOT Collaboration Folder: Instances Logicial Information Object

CFF_LOPR Collaboration Folder: Instances Logicial Information Object

CFF_LORE Collaboration Folder: Instances Logicial Information Object

CFF_LOREPR cFolders: Attributes of Outgoing Relations of LOIOs

CFF_LORI Collaboration Folder: Instances Logicial Information Object

CFF_LORIPR cFolders: Attributes Ingoing Relations of LOIOs

CFF_PHF Collaboration Folders - PHIO: Instances Physical Info: Dat

CFF_PHHR Collaboration Folders - PHIO: Instances Physical Info: Out

CFF_PHHRPR cFolders: Attributes of Hyperlink Relations

CFF_PHIO Collaboration Folders - PHIO: Instances Physical Info: In

CFF_PHIO_TRACK CFF: Tracking the Access (Read- and Write Accesses)

CFF_PHNM Collaboration Folders - PHIO: Instances Physical Info: Ver

CFF_PHNMPR cFolders: Attributes of Target Anchor Relations

CFF_PHPR Collaboration Folders - PHIO: Instances Physical Info: Att

CFF_PHRE Collaboration Folders - PHIO: Instances Physical Info: Out

CFF_PHREPR cFolders: Attributes Outgoing Relations of PHIOs

CFF_PHRI Collaboration Folders - PHIO: Instances Physical Info: In

CFF_PHRIPR cFolders: Attributes Ingoing Relations of PHIOs

thanks

amit

award points for useful answer

[Former Member]

Hi,

Yes i know all this tables. But for my use, i'm not referring this tables, but those tables which i mentioned earlier.

for example, in the table CFS_STATUS_TRANS, there are fields like TRANS_ID, PROFILE_ID etc, which are UUID in character format.

Do you know how to show this field into a normal readable format? Because all this fields are having 32 characters which is not easily readable. If i get a solution for this, then i can generate report in SAP R/3 itself, instead of BW.

Hope you are getting my point and understand my query also.

Thanks & Regards

Ani