Viewing 15 posts - 451 through 465 (of 893 total)
I'll offer my opinion, but in no means should it be seen as a verdict (as I don't have all the facts).
It is a reasonable expectation that (and not only...
May 12, 2015 at 4:24 pm
benjamin.seidle (5/1/2015)
Is this kinda what you are thinking? http://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/
Not really. A bridge table (as described in the above) is useful when you have to represent a many-to-many relationship between a...
May 4, 2015 at 1:58 pm
If you have Office 2013 (x64), this file should not be too large for Excel.
Unless there is a missing delimiter somewhere, a missing row would usually be either in the...
May 4, 2015 at 1:46 pm
Pretty far behind on service packs.
As Eirikur suggested and you've confirmed, AWE should be enabled. You should also ensure that the "Lock Pages In Memory" permission is assigned to the...
May 4, 2015 at 12:37 pm
Are you not maybe using a user-defined hierarchy in the one system, and the attribute hierarchy in the other?
May 1, 2015 at 9:50 am
I usually like to create empty file templates of those files, and replace them with the files I receive from the source. That way you could still execute all your...
May 1, 2015 at 9:43 am
From what I was able to find, the default backup folder of an SSAS instance is neither stored in the registry nor is it accessible through the SSAS DMVs.
It seems...
May 1, 2015 at 8:20 am
I think it is probably a join or dimensional usage issue in your cube. I am not able to reproduce your scenario, and the syntax is definitely ok.
May 1, 2015 at 7:40 am
In my opinion, you have already mentioned the solution...a data mart. What you're doing right now with the views (or indexed views), is taking a shortcut to reporting. It won't...
May 1, 2015 at 7:30 am
In my opinion, it would be best to create a "Geography" dimension which contains Zip Code, County, State, etc.
If the Zip Code attribute of a physician is the only way...
May 1, 2015 at 7:24 am
It could be...the 64-bit computing environment is able to address more memory and is known to use the available memory more effectively.
With that being said, there could be many...
May 1, 2015 at 7:06 am
The ".&[]" notation usually indicates a tuple. If the syntax generated does not contain the ampersand, it means that it is not an actual tuple but a level within the...
May 1, 2015 at 7:00 am
Only other thing I can think of is a configuration file maybe?
April 28, 2015 at 9:29 am
Ensure that the cube's data source uses an account with access to the source database. If it is impersonating the service account, ensure that the service account has access to...
April 21, 2015 at 11:25 am
Seeing that you are storing the configuration values in a database table, you should refer to the SQL Server database encryption options.
The SSIS forum is probably not the best place...
April 21, 2015 at 10:24 am
Viewing 15 posts - 451 through 465 (of 893 total)