|
|
Browse by Tags
- 2005
- Backup
- MDX
- MDX Client
- Microsoft
- miscorosft
- olap
- OLAP Cube
- OLAP Cube / Employee Dimension / Hierarchy
- OLAP cubes
- Reporting Services
- SQL Server
- sql server 2005
- sql server managment studio
- SQL2005
- SSAS
- SSMS
- StrToMember
- time
-
OLAP Cube / Employee Dimension / Hierarchy
Hi I have 'employee' table which has EmployeeID and SupervisorID (self-join) and I join the table to fact table using Username field as the fact table doesn't have EmployeeID. I would like to build Employee hierarchy and I have two questions: 1) What is the standard way of doing that? I presume... -
two parameters from cube in SSRS
I have a SSAS cube and a report in SSRS , i have one fact table, and the same table is also Dimension , is a relationship type :Fact , by one field Id AutoNumber. In a report, i use two fields from the same table like parameters, so when i selects a value of a parameter, the other parameter is bounded... -
Member property as Measure
I have a cube that contains a dimension called 'Project'. The 'Project' has different member properties like 'StartDate', 'End Date', 'DlvDate' and 'Customer'. I have calculated measures: 'Item Cost', 'Hour Cost', 'Comitted Cost'... -
Adding Analysis Services to existing SQL Server 2005 Installation
I have an existing SQL Server 2005 Installation with Service Pack 2 installed and it's running on Windows Server 2003. For this program that I'm trying to run, it's asking me to add Analysis Services to SQL Server 2005. How do I go about doing that without accidentally uninstalling SQL Server... -
Problem: A definition for "Dimension" in Analysis Services / OLAP
Hello: In the Glosary of the BOLs of the SQL Server 2005 you can find the following definition for "Dimension" in Analysis Services: "A structural attribute of a cube, which is an organized hierarchy of categories (levels) that describe data in the fact table. These categories typically... -
Problem: analysis services 2005 cube browser - filter empty rows?
Hi - I'm using the Excel 2007 cube browser functionality paired with an Analysis services 2005 cube. We're able to browse the cube with no issues (ie drag / drop to create ad hoc reports across all dimensions) but there is one problm: even if there is no data for the selected column / dimension... -
Problem: Need help with MDX and # of periods
I need to find the number of months to date but have this appear in the year total line in SSMS. Using the first calculation I end up with 1 in the year total line whereas I need 4 because 4 is the latest month that has data. Year Qtr Month YTD COUNT PERIODS Calculated Member 2009 Q1 JANUARY 1 4 FEBRUARY... -
Problem: Any tools available to help in the backup of OLAP Cubes in SQL 2005
Hi there Does anyone know if there are any tools out there to help with the backup of SQL Server Analysis Services cubes/databases? I know there are tools specifically aimed at the SQL Server Database Engine (SQL LiteSpeed being one that springs to mind) but are there any that are specifically used to... -
Problem: Multiple Fact Tables
Say for instance I have 2 fact tables....both are keyed on a field named AccountKey, and each contain data regarding their own set of Facts....granularity is the same, but one may contain more rows than the other. If I want to include information for both of these fact tables in my cube for analysis... -
Problem: Where can I find an MDX client - > similar to Squirrel SQL but for OLAP / Analysis Services?
I want to dynamically and ad-hoc query an OLAP cube (Microsoft SQl Server 2005 Analysis Services". I am looking for a client front end, similar to an SQL Client such as Squirrel SEL , but capable to connect to an OLAP cube and capable of sending MDX queries and presenting the results. I know ho...