|
|
Browse by Tags
- 2005
- 2147217900
- ado
- Analysis Server
- Analysis Services
- Analysys Services
- Anlysis services
- AS2008
- average
- bug
- bug rates
- calculated
- Calculated Member
- Case
- click through
- connection
- convert
- count
- crystal
- cube
- cubes
- date
- datetime
- drill down
- dummies
- Excel 2007
- hierarchies
- hierarchy
- kpi
- leaf
- leaves
- level
- loop
- lowest
- MDX basics (members/Children)
- member
- Microsoft
- multiple
- multiple states
- olap
- OLAP cubes
- Order function
- parameters
- Pivot Table
- queries
- query
- rates
- report
- reporting
- Reporting Server
- reports
- SQL
- SQL Server
- sql server 2005
- SQL Server 2005 Reporting Services
- SQL Server Analysis Services
- sql server managment studio
- SQL Server Reporting Services
- SQL2005
- SSA
- SSAS
- SSAS 2008
- SSMS
- SSRS
- SSRS 2005
- SSRS 2008
- SSRS2008
- state
- statement
- states
- StrToMember
- sum
- Syntax
- tfs
- Using a named set as dimension.
- VB expression
- Visual Studio 2005
-
Using a named set as dimension.
I used a named set in AS 2000 called R18. It contained all month members eg. 200806,200807....201001,201002. In a pivotable in Excel 2007 connected to the AS2000 cube you could see in under the Time dimension and just drag it out and put as rowheaders. It would then dynamicly change when todays date... -
MDX basics (members/Children)
Hi I've started building my first cube after finishing a book (a while ago) and I just realized that to understad better cubes I just need to learn/practise MDX basics :) So can someone explain me the difference between members and children on real life (simple) examples? My only difference after... -
SSAS what should I know?
Hi Everyone, I would like to learn more about SSAS = understand it and I hope more experienced SSAS developers could share their knowledge :) I'm ok in understanding data sources and data source views, cubes makes some kind of sense although it details i'm still a bit lost, dimensions makes sense... -
Getting previous member in VB expression for default value in SSRS 2008
I have the following code in my expression to get as default the current week of the month. What I actually need is to get the last member from the [Dim Date].[Week of Year] member, so that f.ex. today is week 9 but I would like to show week 8 as default value. Is this possible in my case? Code Snippet... -
MDX query to extract dimensions related to multiple fact tables
How do we extract Members from a Dimension related to Multiple Fact_tables using MDX in SQL Server Analysis server 2005 with WHERE condition? For example: "Company" and "Affiliate" dimension members are(a,b,c,d) and (NJ,CAL) respectively, this dimensions are linked to 2 fact tables... -
Can Crystal reports query Microsoft OLAP cubes using MDX queries
I am new to Crystal Reports. Can I connect to an OLAP cube and retrieve data from it using an MDX query. What are the steps I need to take to query a Cube and create a report based on the data? Thanks, FT -
MDX - Aggregation
I´ve constructed a DimDateMonth Dimension which hold only Year-Quarter-Month values, included in this dimension is the number of working days in the current month. I have two hierarchies a) Year-Quarter-Month and b)Year-Month and an Number Of Working Days In Month attribute (bound to the key) I´ve created... -
OLAP MDX average problem
Hello I have an MDX problem that need's solving, I'm new to OLAP so if anyone could point me in the right direction; it'd make my week. These are sample dimensions for the time dimension in the cube I'm building. The numbers represent the sum of a particular measure at each level. Time... -
MDX Recursive Critical Problem
Dear Friends, I have this calculated member that If I execute for begin of the year like 2007-01-02, takes 2 seconds, but If I executed for a date in the end of the year like 2007-12-31, it takes hours or return a bug! The problem is the recursive calculation... how can I fix the critical problem? Is... -
Problem with default values in SSRS2008
I'm trying to make the default value for certain parameter be the lastvalue in my Full Date attribute, but can't seems to find the appropriated code to do so. In Parameter Properties -> Default Values I choose "Get values from a query", where the query is the one attached in the...