I'm working on a problem where i need to process multi dimensional data in memory using C#. My requirement resemble OLAP cubes but are not as complex. for example i don't need calculations or aggregation or stuff like that. I basically would like to reference data using multidimensional keys. for example: var key = new Key(); key["Dim1...
I'm relatively new to MDX and am trying to accomplish what I think should be an easy thing, but I haven't found any solution. I have a sales cube and one of the measure is profit which can be negative or positive. I want to get one measure which is effectively the sum of positive profit, i.e. only include in the new measure those profit...
I'm new to modeling star schemas, fresh from reading the Data Warehouse Toolkit. I have a business process that has clients and non-clients calling into conference calls with some of our employees. My fact table, call it "Audience", will contain a measure of how long an attending person was connected to the call, and the cost of this ...
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 2000 I want to provide a report ...
Has anyone used JackBe mashups in a SharePoint environment hitting OLAP cubes with PerformancePoint 2007? Any gotchas? Our client is evaluating adding JackBe to our enterprise toolkit and they're soliciting technical recommendations... ...
Hi, i'm having problem restricting a query in mdx, using except function at where clause. i need to retrieved a set of data but which not in an specific set. Then i created the next query: select {[Measures].[Amount], [Measures].[Transaction Cost], [Measures].[Transaction Number]} ON COLUMNS,{[ManualProcessing].[All ManualProcessings].[...
In my Analysis Service OLAP Cube I would like to exclude facts having unrelated dimensions, which during processing produce errors. I would also like to avoid making Named Queries in Data Source View (with specific WHERE conditions). Is there any way to do this at the level of a cube? What is the easiest way to accomplish this? (I am ...
I'm trying to set the Calculation property on an OLAP PivotField with VSTO 3.0. For example: pivotField.Calculation = XlPivotFieldCalculation.PercentOf; If I do the above, the value I assign does not stay (Excel appears to revert the change). I suspect the reason is that the BaseField property of the PivotField also needs to be popu...
I have 1M words in my dictionary. Whenever a user issue a query on my website, I will see if the query contains the words in my dictionary and increment the counter corresponding to them individually. Here is the example, say if a user type in "Obama is a president" and "Obama" and "president" are in my dictionary, then I should incremen...
Does anyone know of an example of how to dynamically define and build ADO MD (ActiveX Data Objects Multidimensional) catalogs and cube definitions with a set of data other than a database? Background: we have a huge amount of data in our application that we export to a database and then query using the usual SQL joins, groups, sums etc ...
I have a user asking me to list the dimensions and dimension attributes of our SSAS cube. I susspect I could generate this via AMO, but I'm wondering if there's an MDX query or SSMS option to show the same info. Any ideas? ...
In Business Intelligence Developer Studio, I'm wondering why one would want to create a report model from an OLAP cube. As far as I understand it, OLAP cubes and report models are both business-oriented views of underlying structures (usually relational databases) that may not mean much to a business user. The cube is a multidimensio...
I was taking a look at Star Schema Benchmark and then I was thinking is it possible to denormalize all tables from the SSB? So database size will increase a lot but potentially the performance will grow up. Is that right? Is it possible? Thanks and sorry for my poor English. ...
I am trying to build a calculated measure in SSAS that incorporates a dimension parameter. I have two facts: Members & Orders and one Dimension: Date. Members represents all the unique members on my site. Orders are related to members by a fact key representing a unique user. Orders also contains a key representing the vendor for an orde...
I would like to create a calculated measure that sums up only a specific subset of records in my fact table based on a dimension attribute. Given: Dimension Date LedgerLineItem {Charge, Payment, Write-Off, Copay, Credit} Measures LedgerAmount Relationships * LedgerLineItem is a degenerate dimension of FactLedger ...
I am looking for a way to connect to a MS Analysis Services OLAP cube, run MDX queries, and pull the results into Python. In other words, exactly what Excel does. Is there a solution in Python that would let me do that? Someone with a similar question going pointed to Django's ORM. As much as I like the framework, this is not what I am ...
Hello, how can I create a cube olap with oracle, how load the data from sources tou the dimentions and the fact table in the cube and how can I query this cube within a java Application. thanks for your help ...
Hello, I'm new to MDX and have a problem regarding filtering out values from a summation. We want to perform normalization calculations, specifically a quantity (q) divided by a basis (b) to get an Intensity (I). The formula is fairly simple I=q/b. OUR CUBE STRUCTURE: We have fact tables FactQuantity and FactBasis, each of which are ...
I have been assigned to a project to create a activity based costing system using Cognos TM1. I'm familiar with a number of other OLAP tools but have zero experience with TM1. Can anyone suggest a good book (searching doesn't turn up anything obvious) or any good online resources? ...
I am preparing an offer for a customer. They proide weekly data to different organizations. There is huge amount data suits OLAP that needed to be visualized with charts and pivot tables on web and custom reports will be built by non-it persons (an easy gui). They will enter a date range, location which data columns to be included and ge...