Jonathan Mallia (10/22/2012)

---

Hi everyone,

I need help with building a Cube Calculation.

I have this MDX below that works OK. It shows the vehicles that are sold an and the profit made...

hpatelc (10/16/2012)

---

hello

I am getting error when i am processing qube on instance . But it works fine on one instance but not on the other one.

Error is "Process failed. Trace...

Smash125 (10/19/2012)

---

I am trying ti build hierarchy based on FirstName,MiddleName,LastName,ContactID

My Dimension table contains

ContactID,EmailAddress,FirstName,LastName,MiddleName,Phone,Title

My Hierarchy

FullName - Showing Error in the header saying 'attribute relationship do not exist between one or more...

CELKO (10/12/2012)

---

You need a course in basic data modeling. There is no such entity as a “status” or “phase” in RDBMS. Those are attribute properties and are part of a...

Jeff Moden (10/11/2012)

---

I believe the following will do as you ask. I call it a "data smear" (because it "smears" the largest value "down" through the returned rows) for...

Sean Lange (10/11/2012)

---

select *,

Case

when StatusName IN ('A', 'B') then 1

when StatusName IN ('C', 'D', 'E') then 2

when StatusName = 'F' then 3

when StatusName = 'G' then 4

when StatusName...

CREATE TABLE Status

(

StatusName Varchar(10)

)

CREATE TABLE Phase

(

PhaseName Varchar(10) NOT NULL

)

CREATE TABLE Subject_status

(

SubjectName Varchar(10) NOT NULL,

StatusName Varchar(10) NOT NULL,

Date [Date] NOT NULL

)

INSERT INTO Status VALUES ('A')

INSERT INTO Status VALUES ('B')

INSERT INTO Status...

Sean Lange (10/11/2012)

---

Please help me with the sql code.

All of them are Varchars (Status and Phase even though they look like Integers).

Please don't ask me to change my Datamodel.. Thanks...

Not actually homework.

I have tried this using a case statement, but when ever the status changes the Phase also keeps changing, so I am checking if there is a way...

Can you please elaborate more.. This is my...

Growth size is 8KB and 10% on the...

vani_r14 (9/19/2012)

---

Hi there

can you please clarify - if my understanding is correct -

You would like to group BC1, BC2, BC3, BC4, BC5 as one group

if that is the...

Hi, I need to get status names as columns and their respective dates as rows. I know its pivoting, but asking you guys for more insight.

Thanks

Jeff Moden (9/10/2012)

---

The test data setup you provided is great. Could you also describe what you want done with it? The result set doesn' give many hints as to...

Greg Snidow (9/6/2012)

---

Sean Lange (9/6/2012)

---

[I can't begin to understand how you get your output based on the data in these tables. It seems you need provide a LOT more detailed...