Can I edit the view sql, can I create view from excel?
16 August, 2012
Hi,
I have tried to develop the report via the evaluation version and I have some questions that need your advice.
-Are there any other ways to edit SQL command from below screen in the process of view creation?
-If I would like to create view by using excel as a data source, Is it possible for me to do so?
-If I would like to change the field format from numeric to string or text, can I do that? (I�ve just only see the options that not related to text or string).
Thanks
I have tried to develop the report via the evaluation version and I have some questions that need your advice.
-Are there any other ways to edit SQL command from below screen in the process of view creation?
-If I would like to create view by using excel as a data source, Is it possible for me to do so?
-If I would like to change the field format from numeric to string or text, can I do that? (I�ve just only see the options that not related to text or string).
Thanks
Hi Narumon,
If you would like to create a report by adding/editing SQL code then you should use either the Freehand SQL method of View creation or a Virtual Table rather than the Drag and Drop method.
Regarding Excel, yes you can create views using Excel as a data source, Yellowfin version 6.1 has many fine new features to do with this. There are two different to do this as explained in this wiki page.
You can change the way a field is interpreted by setting its meta-data definition, for example, you can set an integer to be a dimension (text) rather than a metric.
I hope that helps you in getting more familiar with Yellowfin and its many possibilities, please keep in mind that there is much information to be found in our wiki pages and also our forum.
Regards,
David
If you would like to create a report by adding/editing SQL code then you should use either the Freehand SQL method of View creation or a Virtual Table rather than the Drag and Drop method.
Regarding Excel, yes you can create views using Excel as a data source, Yellowfin version 6.1 has many fine new features to do with this. There are two different to do this as explained in this wiki page.
You can change the way a field is interpreted by setting its meta-data definition, for example, you can set an integer to be a dimension (text) rather than a metric.
I hope that helps you in getting more familiar with Yellowfin and its many possibilities, please keep in mind that there is much information to be found in our wiki pages and also our forum.
Regards,
David
Hi David,
Thanks for your advice.
Regards,
Narumon
Thanks for your advice.
Regards,
Narumon