Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook

Post Reply
JohnO
Posts: 52
Joined: Mon Jul 29, 2019 5:02 am
OLAP Product: Planning Analytics
Version: 2.0.9.x
Excel Version: Office 365 16

Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook

Post by JohnO »

I'm wondering if there is any existing method / has anyone written and VBA code to basically scan a worksheet/workbook and extract a list of all DBRW's/ DBR's (Maybe other worksheet functions) and the parameters being referenced (If they are formula parameters then the values that the parameters convert to). So the extract would basically be: Worksheet name, cell address, full formula containing the evaluated parameters).
ascheevel
Community Contributor
Posts: 244
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook

Post by ascheevel »

This might be a good starting point for you writing your own solution.
User avatar
Mike Cowie
Site Admin
Posts: 479
Joined: Sun May 11, 2008 7:07 pm
OLAP Product: IBM TM1/PA, SSAS, and more
Version: Anything thru 11.x
Excel Version: 2003 - Office 365
Location: Alabama, USA
Contact:

Re: Reverse engineering existing workbooks. Is there a method to document all DBRW's in a worksheet/ workbook

Post by Mike Cowie »

JohnO wrote: Tue Nov 29, 2022 10:14 pm I'm wondering if there is any existing method / has anyone written and VBA code to basically scan a worksheet/workbook and extract a list of all DBRW's/ DBR's (Maybe other worksheet functions) and the parameters being referenced (If they are formula parameters then the values that the parameters convert to). So the extract would basically be: Worksheet name, cell address, full formula containing the evaluated parameters).
Hi JohnO,

Not sure if this free, TM1-specific Audit Report tool, which you can download from here, might be of use.

Regards,
Mike Cowie
QueBIT Consulting, LLC

Are you lost without Print Reports in Planning Analytics for Excel (PAfE)? Get it back today, for free, with Print Reports for IBM Planning Analytics for Excel!
Post Reply