Viewing 15 posts - 1,021 through 1,035 (of 1,174 total)
Agree in this scenario it's for a BI application and I doubt it can handle self joins
Maybe I am reading you wrong but I take it you are writing the...
May 1, 2013 at 11:32 am
Hi, are you using a stored procedure in your dataset definition or are you typing in the query directly?
May 1, 2013 at 11:01 am
I am not sure you can accurately partition your articles without that company identity column. Are the company names consistent across the tables that you can join to the company...
April 30, 2013 at 11:29 am
When you want to schedule the job, do you need to provide the package password in the agent configuration? If so would you need to restrict access to who can...
April 30, 2013 at 11:10 am
Are the latencies in data similar? In your old report you may have had access to up to the minute data whereas in the new cube current is defined as...
April 30, 2013 at 11:06 am
Craig makes a good point above. In a small organisation you don't have as many developers and you are likely to be familiar with all ETL processing. There is little...
April 26, 2013 at 10:42 am
I've seen it where many developers create ETLs and thus a dedicated server makes sure they are all stored in production in one location, regardless of the servers that are...
April 25, 2013 at 11:09 am
My version of this is: "If column definitions in either the source or the destination are different, for any of the files, it will not work"
If the above is not...
April 24, 2013 at 12:27 pm
What RAID type are you using? Maybe a hardware based 0+1 is needed. This is recommended for mission critical 24/7 systems.
April 24, 2013 at 12:11 pm
Rather than maintain two copies of the same file, Import then move the file all in one loop.
April 24, 2013 at 12:04 pm
I think SSAS does the proper thing by wanting to have all fields defined. In your dimensional database, It is common to put a -1 key to represent a null...
April 24, 2013 at 11:50 am
Snapshot replication is usually a good option if you generally have lots of activity happening on a large database. I would not recommend snapshot replication since this would replace the...
April 18, 2013 at 10:58 am
One issue with stored procedures in reporting services is that if the stored procedure is quite complex, e.g. has multiple select statements, that SSRS has trouble parsing them correctly to...
April 18, 2013 at 10:50 am
Try this also...
With Member [Measures].[Thing Count YTD] As
AGGREGATE(YTD([Effective Date].[Year-Week].CurrentMember)
, [Measures].[Thing Count] )
SELECT
[Measures].[Thing Count YTD] ON 0,
[Effective Date].[Year-Week].[Week].[2013 Week 6] ON 1
FROM
[Cube]
This keeps whatever it is you are...
April 18, 2013 at 10:42 am
Viewing 15 posts - 1,021 through 1,035 (of 1,174 total)