Everytime we create a cube for analysis services Date and Time Dimensions are needed to slice and dice the historical Data. Sql Server Analysis Services uses the Time Intelligence Features to populate the date and time. Its posted in detail in this blog.
However we need to use them in our relational Databases to do some [...]
Jan
20
2010
20
2010
SQL SERVER :Date and Time Dimensions in T-SQL using CTE
Jan
20
2010
20
2010
Running SQL Reporting Services Report from SSIS
Whenever you create a new Subscription in Sql server reporting services, a new job is created under the Sql agent as shown in the figure below.
You can use the msdb.dbo.sp_start_job procedure to start the job. In SSIS create a new SQL task and run the job wherever required
exec msdb.dbo.sp_start_job @job_name = ‘JobName’
For more [...]
Jan
17
2010
17
2010
Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system’s console.
You may see the above error if you are using the SQL server Destination in your SSIS package.
Sql server Destination cannot be used in packages that access a SQL Server database on a remote server. Instead use the OLEDB destination.
Things to note for SQL Server Destination
a. It offers the same speed as the Bulk [...]
Dec
18
2009
18
2009
Reporting Services ToolTips
One good feature in SQL server Reporting Services is ToolTip . It is a simple feature but has more advantages if you want to show the complete information in a report. Its a great way of saving some Reporting space.I use it when Designing Dashboards or if you want add the redundant columns like the [...]
Dec
7
2009
7
2009
Creating a simple FrontEnd using Reporting Services and Merge
Problem:
A Business User wants to update/insert/delete the values in a table that sits in the metadata of the Datawarehouse on a regular basis. Based on these values numerous calculations will be done in the warehouse which generates a data driven Report on a weekly basis.
Initially I got the following Solutions
1. Create a frontend app [...]
Nov
7
2009
7
2009
Encryption in SQL SERVER using SSIS
I have been recently working on an Sql Server Encryption Project. It includes getting the data from a source and importing them into the Datawarehouse via the ETL(SSIS in this case) and then Encrypting it. I decided to blog on Encryption to share my experience.
a. When you Encrypt the Data in SSIS make sure you [...]
Oct
13
2009
13
2009
Checking TSQL in SQL Server Reporting Services Datasets
Recently I have been checking all the Dependencies on the Reports in SSRS(Sql server Reporting Services) because of a Major deployment on the ETL. The ETL change was to accomodate the transfer of a few columns from old Table TableA to the new table TableB. Some of the Datasets in the Reports are Stored Procedures [...]
Sep
17
2009
17
2009
Reporting Services Date Format
Many Clients have varied Requirements for Dates. You can do the conversions in Date format using T-SQL from the following link in MSDN.
In reporting services you can convert datetime using the customs visual basic datetime formats using Expressions.
Here are the following links on MSDN for Visual Basic Datetime Formats
Predefined DateTime Formats
Using Format Function
Sep
8
2009
8
2009
Report Server Names for Instances
If the sql server reporting services is configured on the server called “SQLBOX” then the URL is http://SQLbox/reports.
If there is a named instance like SQLBOX\VIVEK then the reporting server URL is http://SQLBOX/reports_vivek
Sep
8
2009
8
2009
Twitter Accounts of BI Experts
Here are the list of Industry BI Experts and their Twitter User accounts
http://spreadsheets.google.com/ccc?key=ppfitTGNfaCuf1l9u4Au4JQ
