Viewing 15 posts - 16 through 30 (of 45 total)
I've included few of them in attachment.
I've 2 index on Salesdate table, both of them are non-clustered, one is for DateID and another one is for Short_SKU which is...
August 13, 2013 at 8:46 pm
You have to go through some tutorial or books on how to build the cubes. You can't directly browse normal database using ssas. You will need to build the cube...
April 29, 2013 at 11:00 pm
Even though I was taught first way, I always use the second way as well π as I have data consistency issue with the first way in many cases. Your...
April 29, 2013 at 10:41 pm
@cstg85 Good idea, would be great if it worked... But in reality it won't I think, as your query needs 2 different type of data source in one...
April 12, 2013 at 1:19 am
I sense long list of code π I've list of tables that I need. 1400 tables are actually 100 tables with 14 different schema. From every schema I use 40...
March 31, 2013 at 9:29 pm
You might want to check Datamicron's Performa, but it's not free I guess.
March 26, 2013 at 4:44 am
I heard Datamicron's Performa is a good tool for such things. It doesn't depend on SharePoint, it is standalone application, and connects to SSAS cubes and PPivot as well. No...
March 20, 2013 at 11:00 pm
Thanks ChrisM@Work, it worked with adding (maxrecursion 365);
at the end.
Later on I'll have to find a way how to do the same thing in the Cube, as it...
January 21, 2013 at 7:32 am
Thanks for idea @demonfox, you have got it right. But how to change it to fit my ChrisM@Work code.
Here is DDL:
--===== Create the table
CREATE TABLE...
January 18, 2013 at 7:25 am
The result is same with my previous query, I think I couldn't explain it right. By requirement for the column remaining it had to sum up all previous remaining cases....
January 16, 2013 at 8:31 pm
Thanks ChrisM@Work, it looks promising. I never thought of minus from total π
just having following error, any idea how to fix that?
Msg 207, Level 16, State 1, Line 22
Invalid column...
January 16, 2013 at 9:33 am
It's too late but still,
I'd suggest you set the CHECKPOINTING to OFF in the job step. It's under the Execution options tab.
January 7, 2013 at 8:24 am
You were right Mackers,
All the time I was changing wrong DSN :w00t:. Forgot that the package works with system DNS only while running in job, and it uses User...
October 22, 2012 at 8:16 pm
I've built that, but you will need to turn those information to numbers in order to create measures. Cube without measure is impossible. Let's say u want to see number...
August 25, 2011 at 12:12 am
Jeff Moden (5/6/2010)
There've been a lot of answers to this question and they could all be unnecessary because SQL Server is very forgiving for most date formats. With that...
June 11, 2011 at 12:43 am
Viewing 15 posts - 16 through 30 (of 45 total)