I have a simple problem, I think, but I have googled and can't find the solution. I have a cube that has MeasureA, MeasureB and MeasureC. Not all three measures have values for each record, sometimes they can be null, it's depending if it was applicable. Now for my totals, I need to average but the average must not take nulls into acc...
I would like to be able to query against an SSAS2008 instance and get a listing of all the catalogs that exist in it, as well as their respective storage sizes. In Management Studio, I can right click on the catalog and go to its properties, which retrieves this data, so I know it exists somewhere. A query that has some of the informat...
I've seen things like this and I was wondering if this was possible, say I run my application and it will show the render on whatever is below it. So basically, rendering on the screen without a window. Possible or a lie? Note: Want to do this on windows and in c++. ...
I must first admit that I'm new to Analysis Services but now must extend an existing complex cube with a new dimension. So its even difficult to tell where my problem is without saying that i dont even have a plan how to start. Ok, i will try to tell what i want to achieve. Given is a Datasourceview with a named calculation 'Returns'. I...
I'm still learning the ropes of OLAP, cubes, and SSAS, but I'm hitting a performance barrier and I'm not sure I understand what is happening. So I have a simple cube, which defines two simple dimensions (type and area), a third Time dimension hierarchy (goes Year->Quarter->Month->Day->Hour->10-Minute), and one measure (sum on a field c...
I'm pretty new to xna development and want to position the Cubes from the Primitives3D sample by passing a position vector to the constructor .. unfortunatly it does not work .. instead it is just spinning arround.. Thats how i modified the code of the cubeprimitive class: public class CubePrimitive : GeometricPrimitive { public ...
Hi, I have a cube that I access via Targit (BI Solution). When I browse / use that cube I want all quantity results to be a zero if null / blank NOT a blank, but no matter what I try I get blanks. I have changed the Null Processing property for the measure in question as well as attempted to change / remove the format string. I still...
I am in the process of designing a new customer fact and dimensions for my warehouse. In my search for good example models I noticed something odd. No one seems to have a customer-centric fact. Every example I found has a transaction event such as a sale or order as the central fact with customers as a dimension. This raises a question f...
Hi, Recently I have been looking into OpenGL, and I've got up to the stage were I want to texture things. I thought I would start with texturing a simple cube. I currently have this code, and understand fully how it works: #include <glut.h> #define WINDOW_WIDTH 400 #define WINDOW_HEIGHT 400 float angle = 30.0f; void Draw() { glLoa...
EDIT: Fixed Hello everybody, I have got the following eventhandler in my Window: private void buttonView_Click(object sender, RoutedEventArgs e) { //Camera PerspectiveCamera camera = new PerspectiveCamera(); camera.LookDirection = new Vector3D(5, -2, -3); camera.Position = new Point3D(-5, 2, 3); camera.UpDirection =...
I'm currently struggling with the creation of a cube. Below is a simplified version of my relational data... Race Id Type Total 1 A 3 2 A 2 Result Id RaceId Gender Position 1 1 M 2 2 1 M 3 3 1 F 1 4 2 F 2 5 2 F 1 In some...
Hello, I have a MDX query that needs to agg some data but filter on leaf nodes. I have a way to do it using DEPENDENTS and EXCEPT, but there can be 10's of thousands of leaf nodes, and filtering out is taking quite a bit of time SELECT { [Measures].[Field1], [Measures].[Field2], [Measures].[Field3], [Me...
Hello Everyone, I am working on Rubik's Cube iphone application. But i am stuck in the middle of the development. I am using SIO2 Gaming Engine for the development. Can anyone please provide some sample source code for Rubik's Cube iphone application. Thanks & Regards Tariq ...
Hey Guys, How can I create a category that shows JUST the items that are in stock now? http://www.lovejungle.com/store Surely it shouldn't be too hard if you can - "Enable out of stock purchases" set to no. h ttp://forums.cubecart.com/index.php?showt...nstock+category ...
I have made 3 planes and positioned them in a way that they make a corner of cube. (For some reasons I don't want to make a cube object). The 3 planes have 3 different Texture2Ds with different images. The strange problem is when I render the 3 objects and start rotating the camera, in some perspectives some parts of these 3 planes don't...
Hello, i'm new to Analysis Services. I have created a dimension on a boolean column. Now users want to have 'yes' and 'no' instead of 'true' and 'false' as result. Thanks. ...
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...
Always in the context of a Rubik's cube app in Java/Opengl with lwjgl, i want to improve my drawing (http://manuelselva.files.wordpress.com/2010/09/cube.gif) in order to have rounded edges for each one of the 27 small cube ? What i would like to acheive at the end is the same as the wikipedia cube picture: http://fr.wikipedia.org/wiki/Fi...
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 all, I'm new to opengl and have been able to learn a lot on my own, but i am stuck on this one. I have a room rendered, but I need a sphere that hovers in the center reflecting everything else perfectly. So far, I've been able to cube map to it with pretty good results, but the 6 textures are all the same: namely, the view I have of...