Tagged Questions

on SQL server family of products, a cube is a set of related measures and dimensions that is used to analyze data.

learn more… | top users | synonyms

-1
votes
1answer
29 views

Draw a cube in Opengl using mouse

I am trying to draw a simple cube in opengl using the mouse. Here's the basic step I followed: 1. Get mouse click coordinates. One,when the mouse is first clicked (say x1,y1) and the other, when the ...
1
vote
1answer
38 views

SSAS Cube process data save in every hour

I have SSAS cube, which process data in every hour, like 10 AM, 11 AM, 12 PM, 13 etc. Now if someone please give me solution, how can I see the processed data details/data snapshot of 10AM, at 12 PM? ...
0
votes
1answer
17 views

Dimensions and MeasureGroups Prcessing

I have 10 dimensions and 10 measuregroups-- each measuregroup is having one partition each. All the cube when processed it takes 5-6 hrs daily. so i thought to process the cube using SSIS analysis ...
0
votes
1answer
22 views

Adding New Partitions to the Measure group in SSAS

I am new to SSAS and got a problem ith adding new partitions to the existing measure group. I have added a new table to the Data Source View and wanted to add this to my existing measure group as a ...
-1
votes
1answer
28 views

Load .png file as a texture to cube ios

I'm trying to load .png file as texture to my cube. [self loadTexture:&myTexture fromFile:@"my_png.png"]; glEnable(GL_TEXTURE_2D); glActiveTexture(GL_TEXTURE); This is a function to load it, ...
0
votes
1answer
9 views

how to build a hierarchy in a cube?

I have built a cube is SSAS. Now i need to create date hierarchy. Please suggest the steps or ways to build the hierarchies. is a attribute and hierarchy are one and the same? which one is the first ...
0
votes
1answer
22 views

Can I keep an image as the face of a cube?

Instead of using geometry.faces[ i ].color.setHex( 0x00ff80 ); to set the color , can I keep and image as the face?
0
votes
1answer
32 views

OpenGL: How to set normals and texture coordinates to a cube

I am making a cube in OpenGL. Normaly I used instant code like: glNormal3f(0.0,1.0,0.0); glTexCoord2f(0.0f,0.0f); glVertex3f( 0.5f, 0.5f,-0.5f); ... which is a bit deprecated. Now I am using ...
-1
votes
1answer
54 views

How to use indices and reduce the number of vectors in a cube

I have a textured cube in XNA which I have taken from a tutorial online. The only thing is, every time I render many of these cubes, it lags. A friend told me I could reduce the number of vectors I am ...
2
votes
1answer
61 views

Best practice for keeping historical data in SQL (for SSAS Cube use)

I am working on an Hotel DB, and the booking table changes a lot since people book and cancel reservation all the time. Trying to find out the best way to convert the booking table to a fact table in ...
1
vote
1answer
36 views

creation of dimension and fact table through source tables

I have imported my flatfiles to SQL Server 2012 and created few tables (source tables). I need to build a cube in SSAS. But I need to make "dimension" and "fact" tables it seems with proper PK/FK ...
0
votes
1answer
26 views

Is it possible to define a calculated member in MDX (ex. Percent of Total) without specific dimension/hierarchy?

Is it possible to define a calculated member in MDX (ex. Percent of Total) without specific dimension/hierarchy? I'm wondering if there's an easier way to get the percent of total of several ...
0
votes
2answers
43 views

Can we use the cube without deploying?

I am new to SSAS and I have created an analysis services project but I don't have premission to deploy the solution on server. So, My question is Can we use cube data without deploying the solution ...
0
votes
1answer
30 views

css 3D transform cube perspective

I'm trying to create a grid of cubes that have a perspective that looks like you're looking at them from the top. Here is an example http://imgur.com/elyJ5tu This one is made by calculating how far ...
0
votes
1answer
37 views

What is the best way to design fact table from relational DB in SSAS

I am designing a data warehouse DB in SQL Server 2012 which will be used to create a cube. Lets say I have 3 tables in the original relational DB Supplier (SupplierId, SupplierName .....) Invoice ...

1 2 3 4 5 … 31
15 30 50 per page