List all the reports and their folders in Infoview

[system]

Is there a way to get a list of all the reports and their respective folders in Infoview. can we export this list to excel?

---

sharique (BOB member since 2005-09-01)

[system]

Sharique,

The complete solution to your question would most likely require using the SDK, however, courtesy of poster “marklee”, he shows a way to create a view of the repository using either Oracle or SQL Server. Please see the posting here:

how to query BO DB repository

I want to query BO dB repository like Microsoft Reporting Services. I now BO repository has encrypted binary data. Maybe there is a way to do that. Does anybody know? bo_rapor (BOB member since 2009-01-03)

Thanks,
John

---

jsanzone (BOB member since 2006-09-12)

[system]

Sharique,

I created a new dimension in my activity universe

Action Type Substring=substring(AUDIT_DETAIL.Detail_Text,1,16)

Now I can get folder paths for my reports by including this in my report window with Document Name and adding a query filter that

Action Type = ‘object folder path’ (DETAIL_TYPE.Detail_Type_Description=‘Object Folder Path’)

The substring and length is totally down to you, 16 just works well for my structure. You might not even want to include it I guess!

---

bolr1 (BOB member since 2008-11-27)

[system]

@bolr1

Sharique,

I created two new dimensions in my activity universe

Action Type Substring =substring(AUDIT_DETAIL.Detail_Text,1,16)

and

Action Type Detail Dim =AUDIT_DETAIL.Detail_Text

(NB - Action Type Detail as a Detail doesn’t seem to work with the first new dimension, I’m told due to the group by statement)

Now I can get folder paths for my reports by including these two in my query and adding a query filter that

Action Type Detail = ‘object folder path’

The substring and length is totally down to you, 16 just works well for my structure. You might not even want to include it I guess!

I have try your way, is your Action Type Detail suppose refer to Detail_Type.Detail_Type_Description=‘object folder path’? I have create

1. Object A=[Detail_Type.Detail_Type_Description]
2. Object B=[AUDIT_DETAIL.Detail_Text]

Object B will represent the folder name.
I have try to filter by Object A=‘object folder path’, but it dint list out all the folder name that my document should have. Eg, my document should have 3 copy in 3 different folder, but it only show me 1 folder.

When i search my dcoument in CMC, it list 3 folder…any idea?

Thanks!

---

ylai20 (BOB member since 2008-05-21)

[system]

Sorry,

Yes that’s right.

Action Type=‘Object Folder Path’ in your Query Filter aqnd Object B in your Result Objects with Document Name or Object Name should provide the results you need.

Note: Object B has to be a Dimension.

I’ll edit my above post to correct.

---

bolr1 (BOB member since 2008-11-27)