User field definitions in Data Dictionary

Yahoo Archive
1
Vic - does that mean that you can also edit the zDataTable and zDataField tables to add a pre-existing sql view?

We have many sql views that we are using excel macros and/or asp's to show complex queries due to the limited functionality of the BAQ wizard. I would ideally want to show these sql views as dashboards, which I presumably could do if they were in the dd.

Thanks

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
>
> Easily? No.
>
> But technically you can do it. If you're a SQL customer, even easier.
>
> Test this in your sandbox environment first, but:
>
> The two tables you're looking for are ZDataTable and ZDataField
>
> ZDataTable is a list of all Vantage tables. ZDataField is a child of ZDataTable and has a list of all columns in all tables and their respective attributes.
>
> The ZDataField.Description is what you would want to modify on UD fields that you've allocated for something. It will be reflected front-side in the Data Dictionary.
>
>
>
> Vic
>
>
>
> ________________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
> Sent: Wednesday, May 12, 2010 11:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] User field definitions in Data Dictionary
>
> Â
> Does anyone know if there is a way to document the use of user custom fields (e.g. Number01, Number02, etc.) in the Data Dictionary? For example, change the definition from Not Used to what we are using it for.
>
2
Does anyone know if there is a way to document the use of user custom fields (e.g. Number01, Number02, etc.) in the Data Dictionary? For example, change the definition from Not Used to what we are using it for.
3
V8 or E9? E9 you can use exctended properties
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Hyndman" <hyndmaninc@...>
Date: Wed, 12 May 2010 15:33:16
To: <vantage@yahoogroups.com>
Subject: [Vantage] User field definitions in Data Dictionary

Does anyone know if there is a way to document the use of user custom fields (e.g. Number01, Number02, etc.) in the Data Dictionary? For example, change the definition from Not Used to what we are using it for.




[Non-text portions of this message have been removed]
4
Easily? No.

But technically you can do it. If you're a SQL customer, even easier.

Test this in your sandbox environment first, but:

The two tables you're looking for are ZDataTable and ZDataField

ZDataTable is a list of all Vantage tables. ZDataField is a child of ZDataTable and has a list of all columns in all tables and their respective attributes.

The ZDataField.Description is what you would want to modify on UD fields that you've allocated for something. It will be reflected front-side in the Data Dictionary.



Vic



________________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
Sent: Wednesday, May 12, 2010 11:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] User field definitions in Data Dictionary

Â
Does anyone know if there is a way to document the use of user custom fields (e.g. Number01, Number02, etc.) in the Data Dictionary? For example, change the definition from Not Used to what we are using it for.
5
I keep an Excel spreadsheet that lists the use of all my user defined fields and user defined tables.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
Sent: Wednesday, May 12, 2010 8:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] User field definitions in Data Dictionary



Does anyone know if there is a way to document the use of user custom fields (e.g. Number01, Number02, etc.) in the Data Dictionary? For example, change the definition from Not Used to what we are using it for.



[Non-text portions of this message have been removed]
6
You know I was wondering about that myself. Right now, we just use an Excel spreadsheet also in V8. The odd thing is that in V6, when you would use a field on a VBForm, the data dictionary would be updated to show that automatically. Then when we converted our database to V8, the data dictionary still holds the old VBForm descriptions of the user defined fields. I may try Vic's method to clean it up.

Adam Whipp

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
>
> Easily? No.
>
> But technically you can do it. If you're a SQL customer, even easier.
>
> Test this in your sandbox environment first, but:
>
> The two tables you're looking for are ZDataTable and ZDataField
>
> ZDataTable is a list of all Vantage tables. ZDataField is a child of ZDataTable and has a list of all columns in all tables and their respective attributes.
>
> The ZDataField.Description is what you would want to modify on UD fields that you've allocated for something. It will be reflected front-side in the Data Dictionary.
>
>
>
> Vic
>
>
>
> ________________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hyndman
> Sent: Wednesday, May 12, 2010 11:33 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] User field definitions in Data Dictionary
>
> Â
> Does anyone know if there is a way to document the use of user custom fields (e.g. Number01, Number02, etc.) in the Data Dictionary? For example, change the definition from Not Used to what we are using it for.
>