Non aggregate measure in cube

Question

I have a FactTable with Flag, this flag is to differentiate records and its of boolean datatype. I have to get this field in the cube. I have created non aggregatable measure for this flag, but it shows blank/null when cube is browsed. I do not want to create degenerate dimension. I want the data to look like this.

Flag| Sales Local
1   | 35,450
0   | 22,000

Is there any other way to get this field into cube, or is it possible?

using a flag is often a sign you are modelling it incorrectly. — Mitch Wheat, Oct 05 '15 at 06:50
Yes, but that is the only way to differentiate records, I need any other way to get this attribute into cube. — Harsha, Oct 05 '15 at 07:21
"but that is the only way to differentiate records" - No, it's not. — Mitch Wheat, Oct 05 '15 at 07:26
A flag is tied to a record in the fact table. If you break up this fact table and want to instead associate this with individual attributes, will it make any sense? I guess not. So the only way you can get the metrics is to have a junk dimension(a separate dimension with 1 and 0) — SouravA, Oct 05 '15 at 08:38
I will buy it. I created junk dimension and linked to fact. Exactly what I needed. Thanks — Harsha, Oct 05 '15 at 14:43

score 0 · Accepted Answer · answered Oct 05 '15 at 07:41

0

The 'dimensional way' to model flags is in a 'Junk' dimension:

Design Tip #113 Creating, Using, and Maintaining Junk Dimensions

answered Oct 05 '15 at 07:41

Mitch Wheat

295,962
43
465
541

I have created Junk Dimension and linked to fact. Exactly what I need. Thank you – Harsha Oct 05 '15 at 14:45

score -1 · Answer 2 · answered Oct 05 '15 at 08:42

-1

A possible workaround would be to add whichever measure that might be required for this column in the cube itself. E.g. Countfoo, Countbar, SumSalesLocalfoo and SumSalesLocalbar. But on the downside, you wont exactly get what you want. But you can get something like:

SumSalesLocalfoo| SumSalesLocalbar
35,450          | 22,000

answered Oct 05 '15 at 08:42

SouravA

5,147
2
24
49

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - [From Review](/review/low-quality-posts/10550405) – Luca Detomi Dec 14 '15 at 07:51
It does answer the question to some extent. If you think it doesn't, request you to come up with one. And if you care to look up, i DID ask my question as a comment. – SouravA Dec 14 '15 at 08:41

Non aggregate measure in cube

2 Answers2