Viewing 11 posts - 16 through 26 (of 26 total)
Hi adzymcfadzy,
MDX differs from TransactSql. Instead of using Filter I suggest you create your set by assigning specific members to the set. Using AdventureWorks something like this:
with
set [x]...
April 29, 2010 at 1:35 am
Hello David,
Just a few (obviously there are more, but my time is limited) benifits I see in using a (SSAS-) Cube versus using SSRS are:
- Performance. During cube processing SSAS...
April 28, 2010 at 5:20 am
Hello Natarscha,
From you example I see that you've used the builtin time intelligence wizard. I don't know the cause of your problem, because I don't know your design,just the few...
April 28, 2010 at 3:37 am
Hello Rick,
As i see it this problem could be caused by the referenced relationship between FactBudget and SaleDate(DimDate). Only the budget facts with a related (referenced) salesfact will be displayed...
April 28, 2010 at 3:19 am
Helo Natascha,
Welcome to the BI-world, hopefully you have a lot of fun and learn a lot. Zbout your questions:
1. When you deploy a cube from BIDS it creates a multidimension...
April 22, 2010 at 5:49 am
Not really a tutorial, but the best I've seen sofar:
MDX.Solutions.with.Microsoft.SQL.Server.Analysis.Services.2005.and.Hyperion.Essbase.
Cees
April 22, 2010 at 5:32 am
Hello Demi,
I'm not sure about your experience with SSAS, therefore just a basic question. If you browse the dimension itself (so not from the cube), can you select the newly...
April 22, 2010 at 5:29 am
Hello Dimitri,
Can you provide more details.
John Smith has 30 Earned Days in total (Right ?),
I would expect that if I select John Smith in the Dimension Person I would...
April 22, 2010 at 5:17 am
Hello Søren
It could be that the mdx you composed is not correct. I've had some difficulties with the aggregate function as well, but if you want to sum your stock...
April 22, 2010 at 5:06 am
Just figured it out my self. It can be done by using the VB command DateSerial. For instance, the following command results in the first date of the current month...
March 24, 2010 at 3:21 pm
Dear I.
I'm not sure what you exactly mean by 'at run time'. Is that while the end-users are querying the cube or during the processing of the cube. Anyway, I've...
March 24, 2010 at 3:13 pm
Viewing 11 posts - 16 through 26 (of 26 total)