SSAS Reporting Action with Date Parameters
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want...
2014-01-22 (first published: 2014-01-20)
2,259 reads
Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want...
2014-01-22 (first published: 2014-01-20)
2,259 reads
If you have a set of measures and some of them are US dollars, some are Euros, and some are...
2014-01-17 (first published: 2014-01-13)
2,064 reads
KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or...
2014-01-09 (first published: 2014-01-06)
2,624 reads
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...
2013-12-30
1,880 reads
When running a For Each Loop through a set of files, sometimes you will have specific files that you do...
2013-12-30 (first published: 2013-12-23)
2,702 reads
A lot of companies have several departments and want to limit the sub sites users can view. For example, the...
2013-12-20 (first published: 2013-12-16)
1,557 reads
When a user is browsing your cube with excel they may not understand how to slice the data and end...
2013-12-09
1,287 reads
When looking at a report and wanting to drill through to get more detail, we often create two reports for...
2013-12-04 (first published: 2013-12-02)
3,015 reads
There are some pretty charts out there and most of them can be done in Reporting Services. There is one...
2013-11-25
1,232 reads
If you get the error in SSIS that says:
…failed with the following error: “No disconnected record set is available for...
2013-11-18
2,532 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers