Capture Y/N (yes or no) in BPC 5.0 SP1

[Former Member]

Does anyone have any other suggestions on how to capture Y/N instead of 1 (one) and 0 (zero) for users submitting an answer to a question?

[Former Member]

Thanks for all the helpful comments.

I think the best solution is to use the 2 = Y and 1 = N solution as this is most simple and achieves the result.

The reason for wanting Y and N is to get those submitting data to afirm that they have followed instructions/rules or agree to policies.

[Former Member]

When you write to the table, sometimes "0" may go as null values and not recognised.

I would stick to Yes/NO.

Ravi Thothadri

[Former Member]

If you truly want to maintain the alphabetic representation of Y/N, then you could investigate storing that value as a COMMENT instead of as a FACT. You still have the dimensionality specification just like storing a FACT (number), but you are storing a COMMENT (alphanumeric) using EVCOM to store and retrieve. If you don't want to maintain history of changing COMMENT values, you would need to implement a stored procedure to remove the extra/duplicate comments on update/insert of the Comment table (there's another thread addressing this).

Otherwise, storing a FACT where 1 is Yes and 0 is No is perfectly acceptable just have all templates convert Yes to 1 and No to 0 on update and 1 to Yes and (0,empty string,null) to No on display. Unless you wanted to distinquish between a No answer and that there never was an answer, then you could pick 2 to be No. It that case, it doesn't matter what values you use to represent Yes/No, just that the end user only sees Yes/No and you hide the actual storage information from them.

[sorin_radulescu]

You have to provide more details.

When you would like to capture the values?

What process are doing?...

[Former Member]

An OLAP cube by definition contains numeric values.

[Former Member]

Personally I would search for another solution rather then sending 1 or zero. Because in case of zero no data is sent to the database, so you don't know if the answer is a zero or if the question is not answered at all. May think about another dimension that has 2 members "Yes" and "No", which can be combined with each question in the account dimension. In this case you can count all "Yes" and "No" answers and analyse which questions are not answered at all (if the roll up of the yes and no member is still zero).

Hope this will guide you to a nice solution!

-Joost