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.
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.
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.
