1# MAQL script
2CREATE DATASET {dataset.quotes} VISUAL(TITLE "St\\tock Qu\totes Data");
3
4# A comment
5CREATE DATASET {dataset.quotes} VISUAL(TITLE "Stock Qu\"otes Data");
6
7CREATE DATASET {dataset.quotes} VISUAL(TITLE "Stock Quotes Data");
8
9ALTER DATASET {dataset.quotes} ADD {attribute.sector};
10
11ALTER DATASET {dataset.quotes} DROP {attribute.symbol};
12
13ALTER DATASET {dataset.quotes} VISUAL(TITLE "Internal Quotes Data");
14
15CREATE ATTRIBUTE {attr.quotes.symbol}
16    VISUAL(TITLE "Symbol", FOLDER {folder.quotes.attr})
17    AS {d_quotes_symbol.nm_symbol};
18
19ALTER ATTRIBUTE {attr.quotes.symbol}
20    ADD LABELS {attr.quotes.company} VISUAL(TITLE "Company")
21    AS {d_quotes_symbol.nm_company};
22
23CREATE FACT {fact.quotes.open_price}
24    VISUAL( TITLE "Open Price", FOLDER {folder.quotes.fact}) AS {f_quotes.f_open_price};
25
26ALTER FACT {fact.quotes.open_price} ADD {f_quotes2.f_open_price};
27
28CREATE FOLDER {folder.quotes.attr}
29    VISUAL ( TITLE "Stock Quotes Data",
30             DESCRIPTION "Stock quotes data obtained from John Doe etc." )
31    TYPE ATTRIBUTE;
32
33ALTER DATATYPE {d_quotes_symbol.nm_symbol} VARCHAR(4),
34    {d_quotes_symbol.nm_symbol} VARCHAR(80),
35    {f_quotes.f_open_price} DECIMAL(10,2);
36
37INCLUDE TEMPLATE "URN:GOODDATA:DATE" MODIFY (IDENTIFIER "my-date", TITLE "quote")
38
39ALTER ATTRIBUTE {attr.quotes.symbol} ADD KEYS {d_quotes_symbol.nm_symbol} PRIMARY;
40
41ALTER ATTRIBUTE {attr.quotes.symbol} DROP KEYS {d_quotes_symbol.nm_symbol};
42
43ALTER FACT {fact.quotes.open_price} ADD {f_quotes2.f_open_price};
44
45# Another comment
46