Data Dictionary

[davidvikings198]

Hi All,

I started a new BI Developer position a few weeks ago and they want me to create a Data Dictionary for a Custom App they have been using.  I created a table with the following information:

As a Dimension:

$Field - Called it Field Name

$Table - Called in Internal Table Name

As an Expression:

=right($Field,len($Field)-Index($Field,'.'))  - Called it Internal Field Name

So my results show the following information

Field Name     Internal Table Name     Internal Field Name

Acct_Grp          IQPTLVendors              Acct_Grp

From there I extracted it Excel so could create some additional Columns that were not in the Application so it appears like this:

Internal Field Name     Visual Field Name     Tab Name>>Chart Object                             Internal Table Name

Acct_Grp                                                       AP Payments>>Type of Business (TOB)       IQPTLVendors

Now here are my questions and need for any feedback would be great:

1.  I am going into each Visual to the dimensions tab Coping the label and pasting it next to the correct Internal Field Name.  IIs there a better way to extract this than Coping and Paste?

2.  The Tab Name>>Chart Object column was my way to identify the Tab in the Application along with which chart object had that Internal Field Name.  Is there a better way to extract this than Coping and Paste?

I hope am going to Copy and Paste for now because I have to get this done but maybe there is something I am missing. 

Thanks,

David

[Lauri · Accepted solution]

1.  I am going into each Visual to the dimensions tab Coping the label and pasting it next to the correct Internal Field Name.  IIs there a better way to extract this than Coping and Paste?

I haven't found a better way than Copy/Paste for copying text from one Visual to another. (It sounds like you have a Visual for each Field Name; if so, you could avoid all that copy/paste by replacing them with a table or chart that uses Internal Field Name as a dimension. But I'm guessing your users have a reason for separate Visuals that you have to respect.)

2.  The Tab Name>>Chart Object column was my way to identify the Tab in the Application along with which chart object had that Internal Field Name.  Is there a better way to extract this than Coping and Paste?

When you say "Tab" do you mean in the data load editor? If so, you could create a table during the load that stores the tab names, but I haven't heard of a way to programmatically capture the tab name. I think you'll have to hard code it in each tab.

[nsetty]

Check out below.

Table Functions

Document Analyzer from Rob.

Document Analyzer 1.14