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