I want to populate a star schema / cube in SSIS / SSAS. I prepared all my dim开发者_开发问答ension tables and my fact table, primary keys etc.
Reports against an SSAS 2005 cube with Currency formatted measures.In Cognos 8.2 a $ 开发者_如何学Gois properly displayed.In Cognos 8.4 an * is displayed instead of a $. Have you encountered this prob
I am calculati开发者_JS百科ng percentages in Analysis Services 2008 using MDX by dividing the sum by the count
I\'m trying to create an MDX query on the TFS cube which gets the historical values of the Estimate field.For each task I want to get the last estimate for each person who set the Estimate field.For e
I am getting the following error when deploying. This is in a cube which was working fine, all that has changed is a key column in one of the dimensions.
In the SQL Server 2005 books online section \"Defining Named Queries in a Data Source View (Analysis Services)\", it states:
I currently use Excel and SQL Server Business intelligence studio to browse my models, but I\'ve been searching high and low for a decent, moderately user-friendly front end application that can be us
For the following query: with member testVal as 0.1234 member testNormal as testVal member testPrepend as testVal, format_string=\"%##.00\"
I am exposing data from a SSAS server to which users can connect from any tool they like, (in practise usually Excel 2007).We would like to provide URLs in some cells and would like Excel to recognise
I\'ve created a cube in SSAS 2008, and have it deployed to my local server. I can connect to the cube via Excel 2007, and the pivot table and pivot chart work perfectly. When I try t开发者_运维技巧o d
加载中,请稍侯......