How can you cascade filter the attributes of more dimensions in a SSAS cube, viewed in Excel 2007. For example, if we have a cube Sales with the dimension Time and dimension Client, once the dimension Time is filtered to show only the sales from a particular date, if "Client.ClientName" is chosen as a filter in the filter area, how can ...
I would like to do something like this: a rotating cube on a form. I don't want to use any external library or dll, just pure .NET 3.5 (without directx). And a cube build with lines only. Could you please tell me how to do this? I don't want to use external libraries because I don't need > 100 MB library to do this thing right? I want o...
dows anybody know any fine open source cube browser??? ideally it would be something built with plain javascript... does it even exists??? I'm planing to use it with classic asp agains a sql database... thanks a lot ...
OK- 3 workbooks (one combined, and two seperate for two different combined areas) are accessing a CUBE reporting database that does a daily extract from Siebel. Each workbook contains approximately 15 sheets, and about 25 pivot tables. When a refresh all is done, and the OLAP query runs, it resets ONE of the filters on almost every s...
I'm attempting to make a chromed cube in GLUT / OpenGL and I'm not sure exactly how to do it. I looked up a "Materials Table" in a textbook which showed "Chrome" as being: Ambient: (0.25, 0.25, 0.25), Diffuse: (0.4, 0.4, 0.4), and Specular: (0.774597,0.774597,0.774597). My question is, how do I create a simple cube and apply this mater...
Hi I need to build a local .cub file for my Excel-using clients. I have scrounged together some VB code but it fails : ConnLocation = "LOCATION=C:\test.cub;" ConnDSN = "SOURCE_DSN=DSN=TEST;UID=test;PWD=pass;" ConnCreateCube = _ "CREATECUBE=CREATE CUBE [TestCube] (" & _ "DIMENSION [account_code]);" Connection = CreateObject("ADODB.Con...
I built an MDX query, to retrieve specific articles from an OLAP Cube. Basically it returns articles below a specific article-category node that are produced by a specific manufacturer: SELECT NON EMPTY ( Hierarchize ( { DrilldownLevel ( { [T DAT Article].[Ar ID].[All] } ) } ) ) DIMENSION PROPERTIES PAR...
Group, We built a data cube using SSAS and are now building SSRS reports off of that cube. Not sure if anyone has come across this, but when you build the report using the wizard and include parameters all looks fine. However if you are in the report after the wizard is compete, and you decide you want to remove one of the parameters y...
I am a newbie to ORACLE. I would like to access an OLAP cube in Oracle using C#. Could you please suggest efficient ways of doing the same? ...
Pardon me for the woolly question - I'm not really that familiar with OLAP & cubes. Let me explain my situation... I'd like to build a database to store questionnaire results, where there might be a few dozen questions per questionnaire. Having gathered a few thousand completed questionnaires, I'd like to analyze the results, and that s...
Is it possible to create a large cube based on existing cube data? We'd like to test the performance of certain tools in combination with SSAS and currently do not have any cubes large enough. e.g. We have a year's worth of data and want to expand it to be 10 year's worth ...
I was trying to compare with the cube's data with that of data mart using TSQL query. It s hard for me to find where the columns used in the cube are coming from. Because the columns used in the cube are coming from data source view, but how do I know which table? Help appreciated ...
I installed, deployed & processed the cube on my CRM system as discussed in the documentation. At no point in this process do I receive any error. From within the Visual Studio Microsoft CRM MSCRM data source view, I can open the tables & run the queries to see data. The problem arises when I try to browse the cube. I have plenty of d...
Is there an easy way to find out the column dependencies between tables in the DSV of a cube? The reason I am asking this question is: When there are lots of tables (fact and dim tables) in the dsv, it is hard to follow the lines. Help appreciated! ...
How do I trace back the actual columns used/joined in calculated measure? THe reason I am asking this question is, I am trying to write the equivalent TSQL query to verify the result with that of calculated measure. So far, my approach has been a look up into the measure properties and find the table/view and the column name used. The j...
Patron Revenue Cube: In one of the calculated measures “Acutal Gross Profit”, there are four measures used as “[Measures].[Acutal Win]-[Measures].[Operator Pay]-[Measures].[Redeeming Dollars]-[Measures].[Redeeming Comp]” The first two measures belong to vw_fact_patronrevenue view and the other two belong to vw_fact_patronredemptio...
Hi, Since I was 13 and playing around with AMOS 3D I've been wanting to learn how to code 3D graphics. Now, 10 years later, I finally think I have have accumulated enough maths to give it a go. I have followed various tutorials, and defined screenX (and screenY, equivalently) as screenX = (pointX * cameraX) / distance (Plus offsets ...
If there is single partition for a measure group, aggregation designed 0%, partition table being used as an empty table (a template), how does the cube browser still show data for the measure in that measure group. FYI: The partitions are generally created monthwise like vw_fact_patronrevenue_2007_1, vw_fact_patronrevenue_2007_2 and so ...
I am writing iphone application where in I need to rotate cube. The rotation on vertical and horizontal axis is working fine. Also, rotating cube from bottom right to top left and from top left to bottom right is working fine.(I am using glrotateef(angle, 1.0, 1.0, 0.0) to rotate from top left to bottom right). The issue here is, I want...
I was just asked to create a report that slices and dices data. We are using postgres. Our schema is setup for OLTP. The system contains orders, they have one status (out of 15+). Orders are also decorated with various properties (8+). The properties are stored in a key/value child table (because they change all the time). End us...