Question: In my cube, I have a measure which needs to have specific aggregate function along each dimension.  

for example `measure="balance"` should have `last value` function for `dimension="Date"` and that measure should have `sum` aggregate function for `dimension="Branch"`. Does Microsoft SSDT 2013 Supports this functionality?

Answer: 
You could use **quoted-idetifier** i.e. **double-quotation marks** around the alias.

From the [docs](http://docs.oracle.com/cd/E11882_01/server.112/e41084/sql_elements008.htm#SQLRF51129),

> 
> Database Object Naming Rules
> 
> 
> Every database object has a name. In a SQL statement, you represent
>  the name of an object with a quoted identifier or a nonquoted
>  identifier.
> 
> 
> * A quoted identifier begins and ends with double quotation marks ("). If you name a schema object using a quoted identifier, then you
>  must use the double quotation marks whenever you refer to that object.
> * A nonquoted identifier is not surrounded by any punctuation.
> 
> 
> 

For example,

```
SQL> SELECT empno as "#" FROM emp WHERE ROWNUM <=5;

         #
----------
      7369
      7499
      7521
      7566
      7654

SQL>

```

Alternatively, in **SQL\*Plus** you could use the **HEADING** command.

For example,

```
SQL> column empno heading #
SQL> SELECT empno FROM emp WHERE ROWNUM <=5;

         #
----------
      7369
      7499
      7521
      7566
      7654

SQL>

```
You can make use of doublequotes for defining special characters as alias.
Tried and tested:

```
SELECT CustomerName AS Customer, ContactName AS "*" FROM Customers;

```