Viewing 11 posts - 1 through 11 (of 11 total)
Have you tried directly adding your folders under:
C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\SQL\Snippets\1033
I would also assume you'd need to include the directory in the XML located in the same directory. Something...
December 19, 2016 at 7:43 pm
Are there any examples for creating an MDX Snippet?
April 7, 2016 at 5:33 am
I might be hallucinating, but I think this may be the correct answer?
SELECT hrc.*
FROM HumanResources.Employee hrc -- children
left join HumanResources.Employee hrdc -- descendants of children
on hrdc.OrganizationNode = hrc.OrganizationNode.GetDescendant(null, null)
WHERE hrc.OrganizationNode.IsDescendantOf(@ParentNode)...
March 11, 2015 at 8:04 am
Is there a list of standard object nomenclature for indexes, procedures, functions, and views (etc) that most teams should follow?
January 15, 2015 at 5:04 am
Actually they are all numbers... and that's an interesting approach. I had always examined it as a pattern matching problem, but I could use the difference to calculate which number...
March 14, 2013 at 7:47 am
Unfortunately, the SKUs aren't all vendor specific, but for those that are I could implement narrowing down the product number to improve performance. This still leaves me with, from this...
March 13, 2013 at 3:13 pm
Nevermind... Figured it out ----
had to use the KEY to filter on, not an attribute! OrderID is the key attribute in the Order dimension used to relate these two...
January 24, 2011 at 10:13 am
It sounds like you're looking for a SSAS Design best practice. This link is for SSAS 2005 but it has a great deal of fundamentals to start from:
http://technet.microsoft.com/en-us/library/cc966399.aspx
Star...
November 8, 2010 at 2:10 pm
Sending view dynamically? I'm not sure if this is possible since your report metadata and structure coudl change if the view changes. If the views have all the same sets...
November 8, 2010 at 2:04 pm
are you looking for a tutorial? you should start with the following.
http://msdn.microsoft.com/en-us/library/ms167048(v=SQL.100).aspx
They have additional information about refinement as well, but I would treat this report model much similar...
November 8, 2010 at 2:01 pm
You can create a new list/table/matrix for each categorization of data. Using the properties of the object, you can append a page break to the object. When exporting to excel...
November 8, 2010 at 1:56 pm
Viewing 11 posts - 1 through 11 (of 11 total)