I have created a calculated measure that computes a weighted ratio for the current balance of all loans that fall into various risk ratings: WITH MEMBER [MEASURES].[Weighted Ratio] AS (Measures.[Current Balance] * [Risk Rating].[Loan Rating Code].CurrentMember.member_value) / ( [Measures].[Current Balance], Ances...
I wrote this fairly simple MDX request to get the rank by sales count of each gender: WITH MEMBER [Measures].[rank] AS RANK( [Gender].CurrentMember, Order( [Gender].Members, [Measures].[salescount], BDESC ), [Measures].[salescount] ) SELECT [Gender].Members ON COLUMNS, [Measures].[ra...
My team is getting ready to start using SQL Server Analysis Services on our project but none of us have a lot of experience with it. What's a good screencast we can watch to get us started? ...
Hello, I want to add analytics and reports to my application on Google App Engine. Can you tell me how I can do that on google's "database"? Are there any oss libraries/tools available? Thank you ...
Hi There, I have question about SAP BI Course. I have an experience in Supply Chan Management (Material Management, Inventory Control). My friend ask me to just do only BI course and you will get the good Job in SAP Reporting. Is it true? or We need some more courses along with BI. I would appreciate if you could let me know. Thank ...
We have a large POSTGRESQL transactional database (around 70 million rows in all), and have previously created a data warehouse from this (updated daily) to run reports off of. To make this more flexible (as lots of different users require different reports and aren't very good at specifying what they want) we would like to create a mul...
This MDX request works: SELECT [Measures].salescount ON COLUMNS, [Date].[2010] ON ROWS FROM [SalesAnalysis] WHERE [Area].[Shanghai] This one works too (different WHERE condition): SELECT [Measures].salescount ON COLUMNS, [Date].[2010] ON ROWS FROM [SalesAnalysis] WHERE EXCEPT([Product].[All Products].Children, {[Product].[All Produc...