SQLServerCentral.com / Strategies and Ideas / Data Warehousing / Add column to View or use Named Query in DSV? / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 09:16:38 GMT20RE: Add column to View or use Named Query in DSV?http://www.sqlservercentral.com/Forums/Topic1591515-363-1.aspxThanks All. So the View it is then. Luckily I defaulted to the 'right' choice! :-)RegardsLempsterWed, 16 Jul 2014 06:19:23 GMTLempsterRE: Add column to View or use Named Query in DSV?http://www.sqlservercentral.com/Forums/Topic1591515-363-1.aspxAnother vote for the view.The DSV has the tendency to hide things for you, while a view is more straightforward.Also, if the database is in source control it is more obvious to other people that a change took place and that it was the addition of a column.Tue, 15 Jul 2014 07:42:55 GMTKoen VerbeeckRE: Add column to View or use Named Query in DSV?http://www.sqlservercentral.com/Forums/Topic1591515-363-1.aspxI agree with HappyCat, place it in the view. This gives you (or a DBA) more flexibility in performance tuning the query in the view than a column added in the DSV.ThomasTue, 15 Jul 2014 07:35:54 GMTThomas LeBlancRE: Add column to View or use Named Query in DSV?http://www.sqlservercentral.com/Forums/Topic1591515-363-1.aspx[quote][b]Lempster (7/11/2014)[/b][hr]I have a Fact table based on a View. Rather than create a Calculated Measure in the front-end BI application (Tableau), I decided to alter the View to include an extra column based on a CASE statement.It occurred to me subsequently that I could have left the View untouched and instead replaced the View with a Named Query in the Data Source View.My question is: which method is preferred? Does it depend on data volumes? I know that you can't use Named Queries in a DSV if the cube storage mode is ROLAP, but that's not an issue because I'm using MOLAP.ThanksLempster[/quote]Personally, I prefer to create the columns in the view. This means that all applications using the view can use the same definition. Otherwise you may need to create an equivalent value in every application that needs it.Another reason is that the DSV editor is not real special and will reformat your named query to suit itself. This doesn't help with readability of the query.Sun, 13 Jul 2014 22:05:17 GMThappycat59Add column to View or use Named Query in DSV?http://www.sqlservercentral.com/Forums/Topic1591515-363-1.aspxI have a Fact table based on a View. Rather than create a Calculated Measure in the front-end BI application (Tableau), I decided to alter the View to include an extra column based on a CASE statement.It occurred to me subsequently that I could have left the View untouched and instead replaced the View with a Named Query in the Data Source View.My question is: which method is preferred? Does it depend on data volumes? I know that you can't use Named Queries in a DSV if the cube storage mode is ROLAP, but that's not an issue because I'm using MOLAP.ThanksLempsterFri, 11 Jul 2014 03:41:19 GMTLempster