Viewing 15 posts - 1,096 through 1,110 (of 1,248 total)
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
Hi. Have you tried the pivot function?
----------------------------------------------------
April 30, 2013 at 11:21 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
It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.
🙂
----------------------------------------------------
April 18, 2013 at 10:30 am
Sorry to hear this. I won't ask for details.
Cheers
----------------------------------------------------
April 17, 2013 at 11:41 am
Viewing 15 posts - 1,096 through 1,110 (of 1,248 total)