tag:blogger.com,1999:blog-4942998138985707508.post5932326377140532301..comments2023-11-05T06:19:59.661-05:00Comments on What's All The Hype Essbase Blog: SQL and PL SQL Loading Via EASUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4942998138985707508.post-73813512566242543552012-11-13T11:25:56.023-05:002012-11-13T11:25:56.023-05:00A couple of comments about your SQL post.
1. tabl...A couple of comments about your SQL post. <br />1. table Alias names can be good in the query as they reduce the size. In order to use them, you might need to include the from clause in your select statment box. They work just fine. <br />2. Is is good if you use column aliases "Select product as Products" since the alias can be used as a column header in the load rule<br />3. I'm not sure why you say to remove comments. They are helpful for documenting what is being done and typically don't impact the query<br />4.Did you know you can use a substitution variable as the data source name so you can change it between systems when you move the rule? In addition you can use them in the select and where clause as well. GlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.com