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