Hi, I was trying to run the cube script to install the cube-database in the analysis server. I changed the data source to point to the server I wanted, but I got the error as in the title with the error codes Error Code = 0x8007000E, External Code = 0x00000000: I tried the properties of the analysis server too and set the "MemoryLimit...
Hi there, Is there any control around where I can have something like Flex OLAP Data Grid for Silverlight? I tried to create one on my own, but hitting the wall all the time, if there aren't something like this in the market, can we brainstorm a bit on how to approach creating a control like this? Thanks ...
Hi, While processing an SSAS cube, the query that I got from processing window like "under SQL queries 1" is producing resultset, but when the processing is done and the measures are pulled into the brower, the values do not show up. What could be the reason??? ...
1) select non empty [Measures].[carded transactions] on 0, {[Date Dimension].[DATE].&[39446]:[Date Dimension].[DATE].&[39505]} on 1 from [Food and Beverage] where ( FILTER( {( [Revenue Center].[Revenue Center].[Revenue Center] * [Date Dimension].[Fiscal Calendar].[Fiscal Day] * [Date Dimensi...
like non-sql db but for olap. In Opensource of course :) Edit: OLAP engine uses Relational DB underground. For example SAPBW can use Oracle, etc. What I mean is kind of OLAP engine WIHTOUT underlying Relation DB like a sort of Google BigTable with OLAP functionality. OLAP DB can be gigantic since BigTable is about the same amount of D...
I have a SSAS 2005 database with 10 cubes. When I create the cubes from an XMLA script, it works fast, and I can browse cubes from SSMS, just as I should. After processing the cubes during the night, eveyrthing starts to work VERY slow. Opening cube list in SSMS takes few minutes, and it is like this all the time. What can cause this? ...
Dear MDX experts, - Is it possible to get the concurrent calculation based on a record time range? Lets say I have; 'start date', 'end date', 'used', and 'color' available... in my fact table.. Is it possible to get the concurrent of 'used' per time (the biggest sum of 'used' that happened during the same range), if yes - what about c...
In the past I used to build WebAnalytics using OLAP cubes running on MySQL. Now an OLAP cube the way I used it is simply a large table (ok, it was stored a bit smarter than that) where each row is basically a measurement or and aggregated set of measurements. Each measurement has a bunch of dimensions (i.e. which pagename, useragent, ip,...
I am trying to write a report (DB2 9.5 on Solaris) to do the following: I have a set of data, let's say it's an order table. I want to run a report which will give me, for each month, the number of orders per customer, and their "rank" that month. The rank would be based on the number of orders. I was playing around with the RANK() OVER...
We have a table with 17Mil rows containing product attributes, let's say they're: brandID, sizeID, colorID, price, shapeID And we need to query for aggregates by brand and size. Currently we query and filter this data by doing something like this: select brandID, sizeID, count(*) from table where colorID in (1,2,3) and price=10...
In Oracle, what are the pros and cons of using materialized views, and of analytic workspaces? What are the best practices surrounding the use of these features? We have an OLTP system, but would also like to access summary information in reports and interactive decision support tools. ...
I have a huge amount of sales data starting from 2000 till 2009. I want to calculate growth on 2009 sales versus 2008 sales. I also want to calculate share of each product in any particular year or month. Best Regards Wajih ...
We migrated our old ASP app to ASP.NET and can't seem to figure out the cause of this error. Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-...
I'm using SQL Server 2005 Analysis Services and I'm trying to calculate distance inside of an MDX query - so that I can get counts of the items that are near my current location. I've created a dimension with Latitude & Longitude, and have also created a .NET assembly to do the math - but am having a hard time getting it all to work out...
Hello I have lot of data in MS Access, and for analysis I need tools. Might you suggest any tools for data mining and analysis (OLAP)? ...
I have a workbook connected to an external OLAP cube. Previously, when I connected to the external data source and then refreshed all, every pivot table would refresh and show the new data. Now, if I connect to the data source and refresh the pivots, the pivots do not update with new data. The only way I can get it to update is if I m...
We've got a bunch of data the users may want to view windows of and do so quickly. They may want to look at a window of the data that is a day, a week, a month, or an arbitrary beginning and ending data. Sorting and summing up all of this stuff in real time is proving to be painful for us so I got the idea of doing something similar to M...
Someone know some interesting and complete tutorial about how to create a Parent-Child dimension in Server2008? I found a brief introduction in Server2005, but a lot of step are changed. thanks in advance. ...
Hello. I need a help with creating OLAP cube which allows to analyse many-to-many relationship between products and parent-child hierarchy of categories. I have next relational structure: table "Products": "ProductID", "Name" table "Categories": "CategoryID", "Name", "ParentID" (where "ParentID" has FK reference to "CategoryID") table...
Hi , I have defined dimension security in my OLAP cube by creating roles and assigning users to each roles. Each user in a role can only see the location they belong to. When I browse the cube using a role , I see correct location for that role. But, when I browse the cube using "Other User" feature in "Change User" and test it for the...