Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Set
1446 results found
Creating a Rolling Date Range Named set in MDX
Creating a Rolling Date Range Named set in MDX One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January. To create this I use
Author:
MikeDavis
Date: 12/6/2010 Section:
Blog
tags :
Date
,
Date Range
,
Named Set
,
Rolling Date
,
MDX
Creating Named
Set
s In Your Cube
Named sets are simply MDX expressions defined with an alias that return a set of members. If you find yourself writing complex MDX expressions to return a set of members often or if you have a commonly used expression, consider creating a named set. This
Author:
DustinRyan
Date: 11/28/2011 Section:
Blog
tags :
dynamic named set
,
static named set
Creating MDX Named
Set
s
A Set is an expression that defines a set of dimension members, and if you find yourself using the same set over and over again, it would probably be beneficial to created a Named Set. A Named Set is just a set expression that has an alias assigned to it.
Author:
DustinRyan
Date: 10/4/2010 Section:
Blog
tags :
Named Set
,
MDX
SSIS Execute SQL task Error: No disconnected record set is available
SSIS Execute SQL Task Error : No disconnected record set is available for the specified SQL statement. If you get the error in SSIS that says: [Execute SQL Task] Error: Executing the query "INSERT INTO [table].[dbo].[tablename] ([N..." failed with the fol
Author:
MikeDavis
Date: 7/26/2010 Section:
Blog
tags :
Error
,
SQL Task
,
SSIS
MDX: Create a Named
Set
with all but one Member
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all of the members of a hierarchy except one of them. I started with trying to use the filter expression and this worked but was very cumbersome to get the syn
Author:
MikeDavis
Date: 11/22/2010 Section:
Blog
tags :
Named Set
,
SSAS
,
MDX
Create Date Dimension with Fiscal and Time
Here are three scripts that create and Date and Time Dimension and can add the fiscal columns too. First run the Dim Date script first to create the DimDate table. Make sure you change the start date and end date on the script to your preference. Then run
Author:
MikeDavis
Date: 2/4/2011 Section:
Blog
tags :
date
,
Date Dimension
,
dim date
,
dim time
,
dimension
,
fiscal
,
time
,
ssas
Illegal character in File Path
Puzzling. I just set up what you described and it worked fine for me. Here are the screenshots of what I did - maybe you can compare settings to make sure there isn't a difference? First, I set up the variables like this: Then, I set the properties on the
Author:
KeithHyer
Date: 8/24/2011 Section:
Forum
LookUp and LookUpSet Functions New in SSRS 2008 R2
With the release of R2 came a couple of pretty nifty new expressions in SSRS. The LookUp function allows us to perform a look up against a separate data set in our report using a field in our source data set where there is a 1 to 1 relationship. Likewise,
Author:
DustinRyan
Date: 7/27/2011 Section:
Blog
tags :
Join function
,
LookUp function
,
LookUpSet function
,
SSRS 2008 R2
Setting Excel Connection Manager connection string dynamically
I have developed an SSIS package (using BIDS 2005) that requires almost everything to be set dynamically; Connections Managers, package variables, SQL statements executed by Execute SQL tasks etc. The reason for this is that the package is designed to be
Author:
lempster
Date: 11/27/2012 Section:
Forum
tags :
connection manager
,
Dynamic Connection Managers
,
Variables
Ranking Functions: ROW_NUMBER vs RANK vs DENSE_RANK vs NTILE
*** Edited *** Videos now available with title Ranking Functions: http://www.sqlshare.com/profiles/26681/MarcoFrancisco.aspx In SQL Server there is 4 ranking functions: ROW_NUMBER Returns the rank of rows within the partition of a result set, without any
Author:
marcoadf
Date: 2/4/2010 Section:
Blog
tags :
dense_rank
,
ntile
,
rank
,
row_number
,
UEFA
,
ranking functions
MDX Named
Set
Rolling Date Range
In an Analysis Services Cube (SSAS), named sets can be used to filter data. One of the popular request I get for named sets are rolling date ranges. Here are some examples of rolling date range named sets I have created. There are several ways to make thi
Author:
MikeDavis
Date: 4/5/2011 Section:
Blog
tags :
Named Sets
,
Range
,
Rolling Date
,
MDx
Unattended Service Account
I'm attempting to set up the Unattended Services Account for Power Pivot via Sharepoint. My boss set up this server, and I really don't know how he did it. (if he followed the wizards or what...) When I go into Central Admin-->Manage Service Applicatio
Author:
lduvall
Date: 5/15/2012 Section:
Forum
tags :
excel services
,
power pivot
,
sharepoint setup
,
unattended service account
RackRepublic | Modular Universal Rack Systems, One block makes the entire rack.
Hi, I'm Aneeq, Our one universal block makes racks of all sizes and all purposes. My web site is about on racks in warehouse. many people are now what is the benifit of racks. how we can set racks in warehouse. how we set important thing in warehouse.how
Author:
aneeq
Date: 5/4/2011 Section:
Blog
tags :
modular racking
,
rack
,
racking systems
,
rackrepublic
,
racks
,
republic
,
universal
,
warehouse storage
Because the Fortune Cookie tells me to use Configuration Files!
If you have ever developed SSIS packages that would eventually be deployed to a production environment then you've run into this issue. I'm talking about Package Protection Levels. What tends to happen is users set up their packages how they want them, th
Author:
Tyler
Date: 11/18/2011 Section:
Blog
tags :
config
,
configuration
,
Deployment
,
errors
,
Files
,
Package Configurations
,
validation
Drillthrough Action
Hi All, I Have couple of issues in drillthrough development. Please review and give me your valuble suggestions. 1. Is there any way to set Maximum Rows number dynamically with MDX. For example I need to set max rows value based on client input in a DB ta
Author:
Venkat
Date: 3/18/2011 Section:
Forum
tags :
cube action
,
mdx
,
ssis
DB Connection string TRULT Dynamic
I just replied to this post, but it errored out! At any rate, you're probably using a variable to set your connection string and setting that value at design time to a fixed value. Then at run time, you're probably modifying that right? If that is the cas
Author:
briankmcdonald
Date: 4/1/2011 Section:
Forum
tags :
Brian K McDonald
,
Dynamic Connection Managers
,
SQLBIGeek
,
SSIS
Policy for Ad-Hoc Workloads
During my presentation at SQLSaturday 62 in Tampa I was asked by an attendee about having a policy to check the setting for ad-hoc optimization settings. At the time since I was in a bit of a time crunch (and I couldn't remember the exact facet to look un
Author:
sqlchicken
Date: 1/20/2011 Section:
Blog
tags :
pbm
,
policy-based management
,
administration
how to set for each loop execute one time
Moving the file won't do anything for that situation. The ForEach Loop will only process a file one time in each run of the package. The only way that the file would be imported 4 times is if you have 4 copies of the file on the file system, you are actua
Author:
BradSchacht
Date: 9/15/2010 Section:
Forum
tags :
Excel
,
loop
,
ssis
SQL Server Reporting Services - Green bar matrix report
Here's how I've created a 'green-bar' style cross-tab/matrix report. I'm basing the new report on this one: 1) Create an inner row grouping, in this case named 'Count' and given a grouping expression of =1 2) for the cell 'Count', set the property Value =
Author:
domhorton
Date: 1/27/2011 Section:
Blog
tags :
RunningVal
,
CountDistinct
,
Green Bar
,
Green Bar Matrix
,
Matrix
,
Sql Server Reporting Services
,
SSRS
.NET GAC viewability....
Ever wanted to see the full directory structure of the GAC....? Well here is registry hack to enable the viewing of the GAC as you would any other directory in Windows Explorer. 1. Run regedit. 2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\FUSION.
Author:
RobertHarris
Date: 3/4/2011 Section:
Blog
tags :
Assemblies
,
C#
,
C++.NET
,
F#
,
GAC
,
VB.NET
,
.NET
Reference the Previous Record in a Data
Set
with SQL Server 2000
A couple blog posts ago , I discussed using a Common Table Expression (CTE) and the ROW_NUMBER() function to create a field in a data set the retrieves a field in the previous row. But since CTE's and the ROW_NUMBER() function aren't available in SQL Serv
Author:
DustinRyan
Date: 7/14/2010 Section:
Blog
tags :
look up last row
,
reference previous record
,
table variable
Monday Morning Mistakes: Not
Set
ting Memory Limits
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite often with clients and is an important topic to know about as a database administrator. Without further ado, let’s get to our iss
Author:
sqlchicken
Date: 2/28/2012 Section:
Blog
tags :
Monday Morning Mistakes
,
tips
,
Tips and tricks
,
tips-n-tricks
HORIZONTAL OR VERTICAL - PAGE SET UP SSRS
Something very simple that I have learned this week has to do with setting up the page orientation after I have created my report. I kept changing the “Page Setup” in the design view and that was not helping at all because after running the qu
Author:
nube07
Date: 1/13/2012 Section:
Blog
tags :
aper size
,
orizontal
,
SSRS 2008 R2
Passing SSRS T-SQL Values to SSRS MDX Parameters
At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source. A requirement of the report was to create an action that drilled-through to another report. No big deal, right? This is SSRS 101. Well, th
Author:
PatrickLeBlanc
Date: 12/1/2010 Section:
Blog
tags :
MDX
,
T-SQL
,
SSRS
MDS 2012: Part 3–Installing Master Data Services
In the first two parts of this blog series we spent time talking about master data, master data management (MDM) and the architectural patterns that are prevalent in MDM solutions. In this post we will start narrowing our focus to Master Data Services (MD
Author:
cprice1979
Date: 4/23/2012 Section:
Blog
tags :
Master Data management
,
Master Data Services
,
MDM
,
MDS
,
Tips and tricks
Page 1 of 58 (1446 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]