Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: Design
400 results found
Using Dimension Member Property Values in MDX/DataSets/Reports
I get a bit frustrated with accommodating SSAS cube design decisions for SSRS shortcomings. Specifically, it does not make sense in the cube design to set the AttributeHierarchyEnabled property to TRUE for attributes with high cardinality. These attribute
Author:
Timo
Date: 3/30/2011 Section:
Forum
tags :
AttributeHierarchyEnabled
,
custom member property
,
MDX
,
query designer
The many facets of BI
I recently had a client ask me to explain the different types of BI in SQL Server 2012, and explain what each tool could be used for and who the ideal target audience would be. I thought this would be a great blog post, as I’ve heard this question p
Author:
ChrisSchmidt
Date: 11/28/2012 Section:
Blog
tags :
BI
,
Corporate BI
,
PerformancePoint
,
Power View
,
PowerPivot
,
SSAS Multidimensional
,
SSRS
,
Team BI
Create a Dynamic Logo
Design
A custom logo design is most essential for your organization in terms of its brand identity, recognition and reliability. A custom logo design is not something which is not done in a matter of hours, instead, even the simplest form or type of logo design
Author:
thomass
Date: 3/28/2012 Section:
Blog
tags :
logo design
,
logo design service
Database
Design
Designing a database can be a daunting task, especially on a large scale. There are several ways inside of SQL Server Management Studio to do design. You could create your database and right click on the ‘Tables’ node and enter all the information there.
Author:
BradSchacht
Date: 11/18/2009 Section:
Blog
tags :
Design
,
SQL
,
Database
MDX Parameter Suppress Auto Update
I discovered this issue the other day while creating a report from a cube. I used the query designer to build a report with a few parameters. The query designer did a great job of building the MDX for me but the client wanted something a little bit more c
Author:
ChrisAlbrektson
Date: 10/26/2010 Section:
Blog
tags :
MDX
,
Parameters
,
SSRS
,
SuppressAutoUpdate
Relational Database
Design
Mnemonic by Kevin Kline
I managed to attend the SQL Pass session -- Relational Database Design for Utter Newbies by Kevin Kline. He covered the following topics • How to approach a new database design project • How to normalize a relational database up to Third Normal Form (3NF)
Author:
indupriya
Date: 9/16/2010 Section:
Blog
tags :
Key
,
Mnemonic
,
Relational database design
how to use parameter label as database named in dataset
As far as I understand from your problem, you have 2 databases and you want to select data from one table wich has the same name in both databases. Question: Can you select data from both tables when connected to the default database? Can this be a soluti
Author:
marcoadf
Date: 1/15/2012 Section:
Forum
tags :
database
,
Dataset
,
from
,
if
,
multiple
,
parameter
,
select
,
sp
,
Stored Procedure
,
table
Designed for Impatience – Mark of a Successful Website
The end users of any website are an impatient bunch of people. Therefore, web designers in NYC must design a website for impatience. Yes, these are the kind of websites that don’t make users think. They are not simple but can be easily understood. L
Author:
johnsiebert
Date: 12 hours ago Section:
Blog
tags :
web design
,
web designers
Cube
Design
This is not what a cube is designed for. A cube is designed to view the measures sliced up by dimension. Really no built in way to compare one dimension to another. This would take two different queries from the cube. Or you could right some mdx caculatio
Author:
MikeDavis
Date: 2/4/2010 Section:
Forum
tags :
cube
,
dimension
,
fact
,
measure
,
SSAS
SQL lunch #28-SSIS
Design
Patterns 1a: Introduction to SSIS
Design
Patterns
In this three part series SQL Server MVP Andy Leonard will discuss SSIS Design Patterns . Speaker: Andy Leonard Add To Outlook: Add To Calendar Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=J8NSMR&role=attend Date and Time: 8/9/2010 1
Author:
PatrickLeBlanc
Date: 8/8/2010 Section:
Blog
tags :
Speaking
,
SQL Lunch
Normalization vs. Dimensional Modeling
This article is a basic overview and comparison between normalization and dimensional modeling.
Author:
ShawnHarrison
Date: 1/11/2010 Section:
Article
tags :
dimensional
,
fact
,
snowflake
,
star
,
normalization
Writing Parametrized MDX for Reporting Services
In this article, you will learn how to write your own MDX inside of Reporting Services and actually add parameters to the your query. No longer will you be forced to use the Query Designer!
Author:
DevinKnight
Date: 9/30/2010 Section:
Article
tags :
MDX
,
SSRS
SSRS 2008 Snap to Grid
Today in my reporting services class, I was asked how to get the Snap to Grid dots to appear in the designer. Here are some of the areas I checked to see if I could get them to appear: 1. I went to Tools / Options / HTML Designer and from there I chose Ru
Author:
SMcDonald
Date: 7/13/2011 Section:
Blog
tags :
Pragmatic Works
,
Snap to Grid
,
Sql Server Reporting Services
,
SSRS
,
Sherri McDonald
ssas Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
ssas Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
Unable to Edit Package Variable Value in SSDT at
Design
Time
Hi Guys, Help please. Refer to the attached screenshots (SSDT = Screenshot 1; BIDS = Screenshot 2). I have created a dummy SSIS project that loads a text file into SQL Server 2008 R2/2012. Package Variable "var_Landing_Qualified" uses an expression. Is it
Author:
mafiswana
Date: 7/6/2012 Section:
Forum
tags :
sql server 2008 r2
,
SQL Server 2012
,
SSDT
Saving Changes is Not Permitted
Have you ever created a table thinking everything looked amazing and was designed perfect only to come back and need to add to it? Maybe you need to change a data type, add a column, delete a column or move a column. It's an easy fix, right. Just right cl
Author:
BradSchacht
Date: 11/18/2009 Section:
Blog
tags :
Design
,
Editing
,
Tables
Reporting on an SSAS Cube with SSRS 2008
In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.
Author:
DustinRyan
Date: 5/7/2010 Section:
Article
tags :
MDX query
,
MDX query designer
,
SSRS cube report
,
SSRS 2008
Creating your first Data Mining Structure and Model
Learn how to built a Data Mining Structure and Model. Understand how a view is set up to support the Data Mining.
Author:
MikeDavis
Date: 8/9/2010 Section:
Article
tags :
Data Mining
,
Mining Model
,
Mining Structure
,
SSAS
MDX/SSRS: How to remove the ALL member from your parameter
This brief blog is for individuals that are new to creating reports from a cube. Since you’re new to creating reports from a cube you still probably rely on using the query designer because maybe you don’t know MDX yet and that’s fine. So pretend you had
Author:
ChrisAlbrektson
Date: 1/19/2011 Section:
Blog
tags :
Children Function
,
Parameter
,
SSRS
,
MDX
What Not to Wear - Reporting Services Style Webinar This Thursday
Please join me this week as I discuss some of the WORST practices of Reporting Services Designs. Please join us for a 1 hour interactive webinar where your reports will go from leopard spandex print to Louis Vuitton. Learn about the options you have to im
Author:
SMcDonald
Date: 9/26/2011 Section:
Blog
tags :
Webinar
Crescent IT Solutions Offers Online Training & Placement on all Software related Business Courses
Crescent IT Solutions which is a high profiled Training Institute offers you SAP(All Modules), Oracle Applications, People Soft, MS.NET, JAVA, QA Testing, QTP, TIBCO, SQL Server, Data warehousing, Business Analyst, PHP, Online Training for the students wh
Author:
crescentitsolutions
Date: 2/24/2012 Section:
Blog
tags :
Data Warehousing Online Training
,
Oracle Online Training
Default Bids to use VB or C#
As you can see below you can default Bids to use VB or C# as the default script language for your SSIS packages. This can be handy if you have a preference in your code language and always forgot to change it. If you forget to change it before you click o
Author:
ChrisAlbrektson
Date: 2/28/2012 Section:
Blog
tags :
BIDS
,
C#
,
Default Code Language
,
VB
Replace traditional DW/BI solution deliver to fully automated with MSBI stack.
Hi, There is a tremendous market demand for timely and accurate information across the enterprise. It is very critical to be able have a 360-degree view of the organization. The status of designing, developing, and deploying Data Warehouse and business In
Author:
wwwnlc111
Date: 3/3/2011 Section:
Forum
tags :
DW
,
DWBI
,
MSBI
,
ProClarity
,
SSAS
,
SSIS
,
SSRS
Actual vs Budget Scenario Dimension
Design
HI Folks, I'm hoping that someone can help me with a design issue that has me stuck! I plan on using a Scenario Dimension which would contain the following members for example: Actual Data Budget Data Forecast Plan Data .... Obviously, I have Actual and B
Author:
jdroach99
Date: 3/8/2011 Section:
Forum
tags :
budget
,
dimension
,
multiple versions
,
scenario
Page 1 of 16 (400 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]