Found a post about this issue here (unfortunately not fixed): https://social.msdn.microsoft.com/Forums/exchange/en-US/76208374-2846-4476-95a4-53baa1c37e4b/mdx-keywords-are-not-colored-in-the-calculation-script-in-sql-server-data-tools-for-vs-20171542?forum=sqlanalysisservices

This has finally been solved.
I had an Microsoft odata driver installed and a package connection manager that used that driver in one of the packages.
Removing that connectoion manager...

fact_sales does have a sales_date but in this case that date should not be used as exchange_rate_date

I should probably have mentioned that it is related to ledger transactions and fact_accounting...

mister.magoo (3/19/2014)

---

You're welcome 🙂

Lets start with the "int" flag version, its does not produce the correct output if you add a value 101 (menas true for month 1, false...

mister.magoo (3/18/2014)

---

Here are three ways you could tackle this. I prefer number three, which is to store the month number as a tinyint.

They all produce the same result, but query...

Jeff Moden (3/18/2014)

---

Gosh. That's 24+2 or 26 bytes to store what could be stored...

ChrisM@Work (3/18/2014)

---

Here's a solution which will work with many values. First the UDF:

ALTER FUNCTION fn_BITWISE_OR

(

@col1 VARCHAR(3)

)

RETURNS VARCHAR(3)

AS

BEGIN

-- try row-wise

DECLARE @LastValue INT

SELECT @LastValue = 000

SELECT @LastValue = @LastValue | d.bit_flag

--...

Sean Lange (3/18/2014)

---

joakim.fenno (3/18/2014)

---

ChrisM@Work (3/18/2014)

---

joakim.fenno (3/18/2014)

---

OK

CREATE TABLE my_table (col1 nvarchar(25) NULL, bit_flag nvarchar(3) NULL)

INSERT INTO my_table VALUES('A', '100'), ('A', '001'),('B', '010'),('A', '001');

expected output from query :

A 101

B 011

The bit_flag column...

ChrisM@Work (3/18/2014)

---

Although just about every reference on the first page returned by Google specifies two operands, the TSQL BITWISE OR actually works with a chain like this:

-- on a...

ChrisM@Work (3/18/2014)

---

joakim.fenno (3/18/2014)

---

OK

CREATE TABLE my_table (col1 nvarchar(25) NULL, bit_flag nvarchar(3) NULL)

INSERT INTO my_table VALUES('A', '100'), ('A', '001'),('B', '010'),('A', '001');

expected output from query :

A 101

B 011

The bit_flag column contains 12 flag...

Sean Lange (3/18/2014)

---

joakim.fenno (3/18/2014)

---

OK

CREATE TABLE my_table (col1 nvarchar(25) NULL, bit_flag nvarchar(3) NULL)

INSERT INTO my_table VALUES('A', '100'), ('A', '001'),('B', '010'),('A', '001');

expected output from query :

A 101

B 011

The bit_flag column contains 12...

ChrisM@Work (3/18/2014)

---

joakim.fenno (3/18/2014)

---

ChrisM@Work (3/18/2014)

---

If you can guarantee that your aggregate function would always and only ever generate the two values required by BITWISE OR, then you will find it far...

ChrisM@Work (3/18/2014)

---

If you can guarantee that your aggregate function would always and only ever generate the two values required by BITWISE OR, then you will find it far far easier...