Hello There I have created a SSAS project and it works perfectly fine my cubes, data-sources and such first time I deploy the cube, but if I change the data in my database and I click Cube>Process in BIDS it will not reflect the new changes even though when I retrieve the table data in SQL server Management Studio the table shows my da...
For interview purpose what questions can we expect from SSAS prespective. a) Entry/Beginners level (1-6 months) b) Intermediate c) Advance Thanks ...
I have a cube with a typical snapshot structure and daily granularity (like inventory quantities). I would like to be able to remove some of the granular data from this cube, because we have something like 270,000,000 rows of source data, cube processing is slow, and there isn't a meaningful difference from one data point to the next, at...
I need a MDX query which returns the top N percent of the rows based on a cumulative sum of a measure. The tricky part is that the set must be ordered based on a different measure than is used for the sum, so using the TopPercent function is not possible. To clarify what I need, here's an example. I want to buy at least 1000 grams of me...
I have within an MDX query the following calculated member: MEMBER [Asset].[Class].[Fixed Income Derivatives (Inflation Linked)] AS ( [Asset].[Class].&[Fixed Income], [Asset].[Sub Class].&[Derivatives], [Asset].[Sub Class Type].&[Inflation] ) This is used within a query as follows: SELECT { [Measures].[Market Value] } O...
Category {A,B,C} Value Currently I can get: Category Value -------- ----- A 100 B 200 C 300 What I'd like to get is: Category Value -------- ----- A 100 B 200 C 300 D 500 Where D is the value of B + C. ...
I have the following star schema: Objects <-> Facts <-> Simulation -ObjectID -ObjectID -SimulationID -SimulationID -SimulationID -ObjHierarchy -Volume -ObjectType Now I'm trying to filter the cube using both dimensions: select [Measures].[Volume] on columns, [Objects].[ObjHierarchy].[Level 0...
Hi, I don't really know how to handle facts that happened over a period of time. I sually deal with facts that happened on a specific date. In clear, my facts have a start_date and an end_date. So, let's say my start_date is 01/01/2008 and my end_date is 01/01/2011. I need to get the number of those facts that happened in 2009 and thos...
I have a SSAS project (simplified) with 3 dimensions: Employer, Location, Time, Department. I have applied security on the Employer dimension, so that users can only see the employers that they are associated with. But the requirement mandates that when the users browse Location dimension, they only see Locations associated with the empl...
The Analysis team wants to analyze sales pipeline data. Our CRM system(Source system) send the Data Warehouse team transaction as the Product moves through the different stages. To mention a few: Creation, CallMade,LeadEngaged,CreditCheck,PapersReceived,Closed.There are more than 100 tracking statuses like mentioned above. Sample tran...
Hello guys, In my project I have to apply security based on a dimension attribute. I think the best way to explain my scenario is with an example, if you need more info please request me and I'll love to told you if it will help me find a solution. I have some main dimension, the dimcustomer, dimseller, fact, data and geographic. The f...
Is there a way to tell the last date / time a partition was processed? I've lots of SSAS databases, with lots of partitions and the automation is not, but will be independently recording when a partition was processed. Is there an independent way to query and confirm? I've looked @ system.discover_partition_stat and system.discover_...
Parent-Child Hierarchy What's the best way to represent a Parent-Child hierarchy in the Cube? I've seen the Usage that can be applied as Parent. I've applied this, for example, ID ParentID CompanyName Rank 1 1 AAA Excellent 2 1 BBB Good 3 1 CCC Ok 4 1 DDD None I can link the ID and Pa...
Am making a cube in SQL Server Analysis Services 2005 and have a question about many to many relationships. I have a many to many relationship between two entities that contains an additional descriptive column as part of the relationship. I understand that I may need to a bridge table to model the relationship but I am not sure where...
Hi Folks, I'm in the middle of designing a SSAS db. I get the theory and the use of this stuff. Here's the thing, I've got a logging database that logs interesting order statuses which I would like to measure time to complete. I've got these tables (not implemented), to measure status times time_dimension user_dimension status_dimens...
Does anyone know of a tool that compares SSAS databases? Not their data, just schema and maybe partition definitions. ...
I have a very simple MDX query that retuns the contents of a dimension. I would like to inject one more row to the result set as part of the MDX. Is this possible? ...
Following on from this question regarding calculating a member I have 2 calculated members defined as: MEMBER [Asset].[Class].[Fixed Income Derivatives] AS AGGREGATE( { [Asset].[Class].&[Fixed Income], [Asset].[Sub Class].&[Derivatives] }, [Measures].CurrentMember ) MEMBER [Asset].[Class].[Fixed Income Non-deri...
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? ...
Hi all, I'm using the follow mdx to keep a running total of the Period Balance measure in my cube: SUM({[Due Date].[Date].CurrentMember.Level.Item(0):[Due Date].[Date].CurrentMember}, [Measures].[Period Balance]) It works great, however it's really slow as the amount of data displayed increases. I can't use a MTD or YTD because the use...