Here is the steps to my problem: I have a MOLAP cube with MOLAP dimensions on the AS2008 server I connect to it with Excel 2007 and save it in a local cube file (.cub) I disconnect from network, then I try to open the offline cub file through excel. It is successful. I copy the .cub file to another machine, start Excel, try to connect ...
We are developeing a BI portal and in that most of the data are from SQL Analysis Service OLAP DB. Please let me know which is the method for using the same in web application like ADOMD.NET, OPENROWSET inside existing SP,... Thanks in advance Bipin ...
I'm wondering if there are any performance implications from adding a lot of calculated members to my cube. On one hand, it's nice to have things defined once, located centrally, tested, and available for use from any client which doesn't support MDX. On the other hand, some of these members I'm adding might not be used very frequently...
I'm rather new to SSAS and am completely stumped on how to solve this problem. I have a dimension called Thresholds. Within the Thresholds dimension there are the following Members: [Threshold Year], [Threshold1 Amount], [Threshold2 Amount], [Threshold3 Amount] I also have a measures called [Qualifying Commission], [Tier1 Amount],...
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, 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??? ...
Starting with the customary - "please excuse me as this is my first post and i'm a relative beginner" disclaimer, i have the following question... I work for a not for profit campaigning organisation, I've set up an SSAS solution to measure campaigning actions (e.g emailing the priminister) taken by a set on campaigners (customers) the ...
Hello I got goal to achieve, 3d cube manipulated with mouse with gradient filling on each wall. I found some source codes coresponding to gradients and 3d rotating cube but here is the problem: When i put these two things together the effect looks like the cube was a wireframe with transparency to some gradient background hidden behind...
Starting with the MDX below I'd like to add two ranking columns that evaluate the member "Close Ratio". The first rank would be based on the sales rep population. Let's say there are 100 reps then if no close ratios repeat the rep with the highest ratio would be number 1 and the rep with the lowest ratio would be number 100. The second...
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...
Edit: I should rephrase this, what would be a relatively easy algorithm to code in Java for solving a Rubik's cube. Efficiency is also important but a secondary consideration. Orig: What is the easiest algorithm to code for solving a Rubik's cube? It could be the least efficient but I am looking for something easy to code right now. ...
If you go to the following link you'll see a really cool Javascript simulation of a cube that rotates based on your mouse position. Simulation: here. If you view the source of the cube rotating script you'll see: <script type="text/javascript"> /* I wrote this script in a few minutes just for fun. It's not made to win any compe...
We are looking for the Flash ActionScript 2.0 code for a 3-D rotating cube to be used to display ads on a website. Any ideas where to start? ...
Hi, is there a way I can sort pivot-table field list (measure names, attributes) by it's caption instead of default by name defined in the cube? Eventually, can I recreate the field list by hand? ...
I'm a relative newcomer to SAP, so please pardon my ignorance. I'm looking to use Java to work with an SAP BI Cube (select, insert, update, delete type of work). At this point, I'm planning on using JCo to execute the appropriate function modules, but I don't know which function modules to use or how to use them. Does anyone have any ex...
I am looking for SSAS cube and MDX (Multidimensional Expressions) sites like our StackOverflow site. Any other resources for SSAS cubes would be welcome as well. ...
We have an Analysis Services cube that needs to be as real-time as possible. It's a relatively small cube that currently takes a couple of seconds to process. Are there any guidelines for this? I'm curious what other folks are doing. Also, what would be the impact of processing the cube too frequently? Would the main concern be th...
Hi everyone! I've been studying the paper condensed cube: the effective approach to reduce the cube size and i have a question, does the min-cube or bu-bst cube store the data by using array? or they store it using tree? Thanks everyone :) ...
I have a DateTime column in my Time dimension table. I want to display this as just MM/DD/YYYY and hide the time component (which is 00:00:00 anyways). How do I do this? ...
I am creating a user hierarchy for product dimension with AdventureWorksDW in a cube. I have added Product Key, ProductCategory Key and Product Subcategory Key attributes. But, its always giving me a warning "create hierarchy in non parent child dimensions" as a tooltip as I hover my mouse pointer over the Dim Product in Attributes windo...