Viewing 15 posts - 2,956 through 2,970 (of 11,678 total)
Finally met Grant at Techorama. He was less scary than I imagined. Maybe because I subdued him with alcohol.
Compromising pictures will be posted later...
May 27, 2014 at 12:22 pm
mario17 (5/27/2014)
May 27, 2014 at 12:19 pm
Right-click on project and convert to project deployment model.
(you are working with VS2010 right?)
May 26, 2014 at 2:34 pm
Jonathan Mallia (5/26/2014)
You would then create a new fact table and a new measure group, linked via datekey and personkey, which would also show in Dimension Usage of the cube?
Yes,...
May 26, 2014 at 2:33 pm
momer79 (5/26/2014)
SQL Server 2008 R2 70-433 exam is still valid and you will get MCTS certification.
Most sources I find contradict this.
Unfortunately, official certification pages by Microsoft seem to be down...
May 26, 2014 at 2:31 pm
momer79 (5/26/2014)
SQL Server 2008 R2 exam is still valid and it is not going expire in near future.One exam would give you MCTS and it will never expire.
I beg to...
May 26, 2014 at 2:29 pm
Jeff Moden (5/26/2014)
Koen Verbeeck (5/26/2014)
Jeff Moden (5/26/2014)
Then you could run a single stored procedure instead of multiple generated packages.But you could run the packages in parallel 😉
As you could with...
May 26, 2014 at 12:36 pm
stevefromOZ (5/26/2014)
Ha Koen, yes and BI edition. I was going old school and looking only at the 2008 editions and supported features.
That IS old school 😀
May 26, 2014 at 11:30 am
You would need to create a factless fact table on top of the dimension. This fact table will be linked to the data dimension and the original person dimension.
May 26, 2014 at 10:48 am
Lynn Pettis (5/26/2014)
I think the answer here is hire a consultant.
Not touching that one... 🙂
May 26, 2014 at 10:30 am
Jeff Moden (5/26/2014)
Then you could run a single stored procedure instead of multiple generated packages.
But you could run the packages in parallel 😉
May 26, 2014 at 10:27 am
Ali-437314 (5/26/2014)
Koen Verbeeck (5/26/2014)
Ali-437314 (5/26/2014)
I don't think so. Although it reads connection string from a table in SQL Server.
That might be the issue.
Check if there are any validation warnings when...
May 26, 2014 at 7:33 am
A solution might be that you generate SSIS packages.
This allows you to deal with the large number of tables in a flexible way.
There is a stairway to BIML on this...
May 26, 2014 at 4:06 am
In the script component there is a different syntax.
May 26, 2014 at 3:21 am
stevefromOZ (5/25/2014)
If you're truly running SQL Express Edition, then no dice - you don't get SSAS with Express, only Standard and Enterprise.
And the Business Intelligence edition 😉
May 26, 2014 at 2:29 am
Viewing 15 posts - 2,956 through 2,970 (of 11,678 total)