Oracle BI 12c: Create Analyses and Dashboards
Даты проведения курса
Array
(
[0] => Array
(
[PRICES] => Array
(
[BASE] => Array
(
[PRICE_ID] => 1
[ID] => 63446
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 150000
[VALUE_NOVAT] => 150000
[DISCOUNT_VALUE_VAT] => 150000
[DISCOUNT_VALUE_NOVAT] => 150000
[ROUND_VALUE_VAT] => 150000
[ROUND_VALUE_NOVAT] => 150000
[VALUE] => 150000
[UNROUND_DISCOUNT_VALUE] => 150000
[DISCOUNT_VALUE] => 150000
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 150 000 руб.
[PRINT_VALUE_VAT] => 150 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 150 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 150 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 150 000 руб.
[PRINT_DISCOUNT_VALUE] => 150 000 руб.
[PRINT_DISCOUNT_DIFF] => 0 руб.
)
)
[PRICE_MATRIX] =>
[MIN_PRICE] => Array
(
[PRICE_ID] => 1
[ID] => 63446
[CAN_ACCESS] => Y
[CAN_BUY] => Y
[MIN_PRICE] => Y
[CURRENCY] => RUB
[VALUE_VAT] => 150000
[VALUE_NOVAT] => 150000
[DISCOUNT_VALUE_VAT] => 150000
[DISCOUNT_VALUE_NOVAT] => 150000
[ROUND_VALUE_VAT] => 150000
[ROUND_VALUE_NOVAT] => 150000
[VALUE] => 150000
[UNROUND_DISCOUNT_VALUE] => 150000
[DISCOUNT_VALUE] => 150000
[DISCOUNT_DIFF] => 0
[DISCOUNT_DIFF_PERCENT] => 0
[VATRATE_VALUE] => 0
[DISCOUNT_VATRATE_VALUE] => 0
[ROUND_VATRATE_VALUE] => 0
[PRINT_VALUE_NOVAT] => 150 000 руб.
[PRINT_VALUE_VAT] => 150 000 руб.
[PRINT_VATRATE_VALUE] => 0 руб.
[PRINT_DISCOUNT_VALUE_NOVAT] => 150 000 руб.
[PRINT_DISCOUNT_VALUE_VAT] => 150 000 руб.
[PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
[PRINT_VALUE] => 150 000 руб.
[PRINT_DISCOUNT_VALUE] => 150 000 руб.
[PRINT_DISCOUNT_DIFF] => 0 руб.
)
[CATALOG_GROUP_ID_1] => 1
[~CATALOG_GROUP_ID_1] => 1
[CATALOG_GROUP_NAME_1] => Базовая цена
[~CATALOG_GROUP_NAME_1] => Базовая цена
[CATALOG_CAN_ACCESS_1] => Y
[~CATALOG_CAN_ACCESS_1] => Y
[CATALOG_CAN_BUY_1] => Y
[~CATALOG_CAN_BUY_1] => Y
[CATALOG_PRICE_ID_1] => 63446
[~CATALOG_PRICE_ID_1] => 63446
[CATALOG_PRICE_1] => 150000.00
[~CATALOG_PRICE_1] => 150000.00
[CATALOG_CURRENCY_1] => RUB
[~CATALOG_CURRENCY_1] => RUB
[CATALOG_QUANTITY_FROM_1] =>
[~CATALOG_QUANTITY_FROM_1] =>
[CATALOG_QUANTITY_TO_1] =>
[~CATALOG_QUANTITY_TO_1] =>
[CATALOG_EXTRA_ID_1] =>
[~CATALOG_EXTRA_ID_1] =>
[ID] => 60990
[~ID] => 60990
[IBLOCK_ID] => 24
[~IBLOCK_ID] => 24
[PROPERTY_85_VALUE] => 53881
[~PROPERTY_85_VALUE] => 53881
[PROPERTY_85_VALUE_ID] => 4904850
[~PROPERTY_85_VALUE_ID] => 4904850
[PROPERTY_DATE_FROM_VALUE] => 18.10.2021
[~PROPERTY_DATE_FROM_VALUE] => 18.10.2021
[PROPERTY_DATE_FROM_VALUE_ID] => 4904857
[~PROPERTY_DATE_FROM_VALUE_ID] => 4904857
[NAME] => Oracle BI 12c: Create Analyses and Dashboards
[~NAME] => Oracle BI 12c: Create Analyses and Dashboards
[PREVIEW_PICTURE] =>
[~PREVIEW_PICTURE] =>
[DETAIL_PICTURE] =>
[~DETAIL_PICTURE] =>
[CATALOG_QUANTITY] => 0
[~CATALOG_QUANTITY] => 0
[CATALOG_QUANTITY_RESERVED] => 0
[~CATALOG_QUANTITY_RESERVED] => 0
[CATALOG_QUANTITY_TRACE] => N
[~CATALOG_QUANTITY_TRACE] => N
[CATALOG_QUANTITY_TRACE_ORIG] => D
[~CATALOG_QUANTITY_TRACE_ORIG] => D
[CATALOG_CAN_BUY_ZERO] => N
[~CATALOG_CAN_BUY_ZERO] => N
[CATALOG_CAN_BUY_ZERO_ORIG] => D
[~CATALOG_CAN_BUY_ZERO_ORIG] => D
[CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[~CATALOG_NEGATIVE_AMOUNT_TRACE] => N
[CATALOG_NEGATIVE_AMOUNT_ORIG] => D
[~CATALOG_NEGATIVE_AMOUNT_ORIG] => D
[CATALOG_SUBSCRIBE] => N
[~CATALOG_SUBSCRIBE] => N
[CATALOG_SUBSCRIBE_ORIG] => D
[~CATALOG_SUBSCRIBE_ORIG] => D
[CATALOG_AVAILABLE] => Y
[~CATALOG_AVAILABLE] => Y
[CATALOG_WEIGHT] => 0
[~CATALOG_WEIGHT] => 0
[CATALOG_WIDTH] =>
[~CATALOG_WIDTH] =>
[CATALOG_LENGTH] =>
[~CATALOG_LENGTH] =>
[CATALOG_HEIGHT] =>
[~CATALOG_HEIGHT] =>
[CATALOG_MEASURE] =>
[~CATALOG_MEASURE] =>
[CATALOG_VAT] =>
[~CATALOG_VAT] =>
[CATALOG_VAT_ID] =>
[~CATALOG_VAT_ID] =>
[CATALOG_VAT_INCLUDED] => N
[~CATALOG_VAT_INCLUDED] => N
[CATALOG_PRICE_TYPE] => S
[~CATALOG_PRICE_TYPE] => S
[CATALOG_RECUR_SCHEME_TYPE] => D
[~CATALOG_RECUR_SCHEME_TYPE] => D
[CATALOG_RECUR_SCHEME_LENGTH] =>
[~CATALOG_RECUR_SCHEME_LENGTH] =>
[CATALOG_TRIAL_PRICE_ID] =>
[~CATALOG_TRIAL_PRICE_ID] =>
[CATALOG_WITHOUT_ORDER] => N
[~CATALOG_WITHOUT_ORDER] => N
[CATALOG_SELECT_BEST_PRICE] => N
[~CATALOG_SELECT_BEST_PRICE] => N
[CATALOG_PURCHASING_PRICE] =>
[~CATALOG_PURCHASING_PRICE] =>
[CATALOG_PURCHASING_CURRENCY] =>
[~CATALOG_PURCHASING_CURRENCY] =>
[CATALOG_TYPE] => 4
[~CATALOG_TYPE] => 4
[CATALOG_BUNDLE] => N
[~CATALOG_BUNDLE] => N
[SORT_HASH] => a14669a2fdf2e062e3e78a304a50cf65
[LINK_ELEMENT_ID] => 53881
[PROPERTIES] => Array
(
[CML2_LINK] => Array
(
[ID] => 85
[IBLOCK_ID] => 24
[NAME] => Элемент каталога
[ACTIVE] => Y
[SORT] => 5
[CODE] => CML2_LINK
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] => CML2_LINK
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 25
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => SKU
[USER_TYPE_SETTINGS] => Array
(
[VIEW] => A
[SHOW_ADD] => N
[MAX_WIDTH] => 0
[MIN_HEIGHT] => 24
[MAX_HEIGHT] => 1000
[BAN_SYM] => ,;
[REP_SYM] =>
[OTHER_REP_SYM] =>
[IBLOCK_MESS] => N
)
[HINT] =>
[~NAME] => Элемент каталога
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 53881
[PROPERTY_VALUE_ID] => 4904850
[DESCRIPTION] =>
[~VALUE] => 53881
[~DESCRIPTION] =>
)
[CITY] => Array
(
[ID] => 92
[IBLOCK_ID] => 24
[NAME] => Город проведения
[ACTIVE] => Y
[SORT] => 500
[CODE] => CITY
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => Y
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Город проведения
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Москва
[PROPERTY_VALUE_ID] => 4904859
[DESCRIPTION] =>
[~VALUE] => Москва
[~DESCRIPTION] =>
)
[MAX_COUNT] => Array
(
[ID] => 100
[IBLOCK_ID] => 24
[NAME] => Исходное количество мест
[ACTIVE] => Y
[SORT] => 500
[CODE] => MAX_COUNT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Исходное количество мест
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[DATE_FROM] => Array
(
[ID] => 101
[IBLOCK_ID] => 24
[NAME] => Начало курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_FROM
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Начало курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 18.10.2021
[PROPERTY_VALUE_ID] => 4904857
[DESCRIPTION] =>
[~VALUE] => 18.10.2021
[~DESCRIPTION] =>
)
[DATE_TO] => Array
(
[ID] => 102
[IBLOCK_ID] => 24
[NAME] => Окончание курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_TO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Окончание курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 22.10.2021
[PROPERTY_VALUE_ID] => 4904858
[DESCRIPTION] =>
[~VALUE] => 22.10.2021
[~DESCRIPTION] =>
)
[FLAG_SALE] => Array
(
[ID] => 141
[IBLOCK_ID] => 24
[NAME] => Скидки
[ACTIVE] => Y
[SORT] => 500
[CODE] => FLAG_SALE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Скидки
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[IN_ACTION] => Array
(
[ID] => 142
[IBLOCK_ID] => 24
[NAME] => Участвует в акциях
[ACTIVE] => Y
[SORT] => 500
[CODE] => IN_ACTION
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => E
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => Y
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 30
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => EList
[USER_TYPE_SETTINGS] => Array
(
[size] => 1
[width] => 0
[group] => N
[multiple] => N
)
[HINT] =>
[~NAME] => Участвует в акциях
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[NEW] => Array
(
[ID] => 144
[IBLOCK_ID] => 24
[NAME] => Новинка
[ACTIVE] => Y
[SORT] => 500
[CODE] => NEW
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Новинка
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
[DURATION_HOURS] => Array
(
[ID] => 174
[IBLOCK_ID] => 24
[NAME] => Длитеность, часов
[ACTIVE] => Y
[SORT] => 500
[CODE] => DURATION_HOURS
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Длитеность, часов
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 40
[PROPERTY_VALUE_ID] => 4904853
[DESCRIPTION] =>
[~VALUE] => 40
[~DESCRIPTION] =>
)
[DURATION_DAYS] => Array
(
[ID] => 175
[IBLOCK_ID] => 24
[NAME] => Длитеность, дней
[ACTIVE] => Y
[SORT] => 500
[CODE] => DURATION_DAYS
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Длитеность, дней
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 5
[PROPERTY_VALUE_ID] => 4904854
[DESCRIPTION] =>
[~VALUE] => 5
[~DESCRIPTION] =>
)
[COURSE_CODE] => Array
(
[ID] => 176
[IBLOCK_ID] => 24
[NAME] => Код курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => COURSE_CODE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Код курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => OBI12cCAD
[PROPERTY_VALUE_ID] => 4904855
[DESCRIPTION] =>
[~VALUE] => OBI12cCAD
[~DESCRIPTION] =>
)
[ACTION_NUMBER] => Array
(
[ID] => 177
[IBLOCK_ID] => 24
[NAME] => Номер акции
[ACTIVE] => Y
[SORT] => 500
[CODE] => ACTION_NUMBER
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Номер акции
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[MARKER] => Array
(
[ID] => 178
[IBLOCK_ID] => 24
[NAME] => Маркер
[ACTIVE] => Y
[SORT] => 500
[CODE] => MARKER
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Маркер
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => Or
[PROPERTY_VALUE_ID] => 4904856
[DESCRIPTION] =>
[~VALUE] => Or
[~DESCRIPTION] =>
)
[HINT] => Array
(
[ID] => 179
[IBLOCK_ID] => 24
[NAME] => Примечание
[ACTIVE] => Y
[SORT] => 500
[CODE] => HINT
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Примечание
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
)
[B_SPECIAL_PRICE] => Array
(
[ID] => 180
[IBLOCK_ID] => 24
[NAME] => B_SPECIAL_PRICE
[ACTIVE] => Y
[SORT] => 500
[CODE] => B_SPECIAL_PRICE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => B_SPECIAL_PRICE
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 0
[PROPERTY_VALUE_ID] => 4904851
[DESCRIPTION] =>
[~VALUE] => 0
[~DESCRIPTION] =>
)
[NORMAL_PRICE] => Array
(
[ID] => 181
[IBLOCK_ID] => 24
[NAME] => Стандартная цена для 1 чел.
[ACTIVE] => Y
[SORT] => 500
[CODE] => NORMAL_PRICE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => N
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Стандартная цена для 1 чел.
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 150000
[PROPERTY_VALUE_ID] => 4904852
[DESCRIPTION] =>
[~VALUE] => 150000
[~DESCRIPTION] =>
)
[SECTION_CODE] => Array
(
[ID] => 186
[IBLOCK_ID] => 24
[NAME] => Подкатегория курса 4
[ACTIVE] => Y
[SORT] => 500
[CODE] => SECTION_CODE
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Подкатегория курса 4
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 10
[PROPERTY_VALUE_ID] => 4904860
[DESCRIPTION] =>
[~VALUE] => 10
[~DESCRIPTION] =>
)
[SHOW_TO_MAIN] => Array
(
[ID] => 189
[IBLOCK_ID] => 24
[NAME] => Показывать на главной
[ACTIVE] => Y
[SORT] => 500
[CODE] => SHOW_TO_MAIN
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => L
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => C
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => N
[FILTRABLE] => N
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] =>
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Показывать на главной
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] =>
[PROPERTY_VALUE_ID] =>
[DESCRIPTION] =>
[~DESCRIPTION] =>
[~VALUE] =>
[VALUE_ENUM_ID] =>
)
)
[DISPLAY_PROPERTIES] => Array
(
[DATE_TO] => Array
(
[ID] => 102
[IBLOCK_ID] => 24
[NAME] => Окончание курса
[ACTIVE] => Y
[SORT] => 500
[CODE] => DATE_TO
[DEFAULT_VALUE] =>
[PROPERTY_TYPE] => S
[ROW_COUNT] => 1
[COL_COUNT] => 30
[LIST_TYPE] => L
[MULTIPLE] => N
[XML_ID] =>
[FILE_TYPE] =>
[MULTIPLE_CNT] => 5
[LINK_IBLOCK_ID] => 0
[WITH_DESCRIPTION] => N
[SEARCHABLE] => Y
[FILTRABLE] => Y
[IS_REQUIRED] => N
[VERSION] => 1
[USER_TYPE] => DateTime
[USER_TYPE_SETTINGS] =>
[HINT] =>
[~NAME] => Окончание курса
[~DEFAULT_VALUE] =>
[VALUE_ENUM] =>
[VALUE_XML_ID] =>
[VALUE_SORT] =>
[VALUE] => 22.10.2021
[PROPERTY_VALUE_ID] => 4904858
[DESCRIPTION] =>
[~VALUE] => 22.10.2021
[~DESCRIPTION] =>
[DISPLAY_VALUE] => 22.10.2021
)
)
[PRODUCT] => Array
(
[TYPE] => 4
[AVAILABLE] => Y
[MEASURE] =>
[VAT_ID] =>
[VAT_RATE] =>
[VAT_INCLUDED] => N
[QUANTITY] => 0
[QUANTITY_TRACE] => N
[CAN_BUY_ZERO] => N
[SUBSCRIPTION] =>
[BUNDLE] => N
)
[ITEM_PRICE_MODE] => S
[ITEM_PRICES] => Array
(
[0] => Array
(
[UNROUND_BASE_PRICE] => 150000
[UNROUND_PRICE] => 150000
[BASE_PRICE] => 150000
[PRICE] => 150000
[ID] => 63446
[PRICE_TYPE_ID] => 1
[CURRENCY] => RUB
[DISCOUNT] => 0
[PERCENT] => 0
[VAT] => 0
[QUANTITY_FROM] =>
[QUANTITY_TO] =>
[QUANTITY_HASH] => ZERO-INF
[MEASURE_RATIO_ID] =>
[PRINT_BASE_PRICE] => 150 000 руб.
[RATIO_BASE_PRICE] => 150000
[PRINT_RATIO_BASE_PRICE] => 150 000 руб.
[PRINT_PRICE] => 150 000 руб.
[RATIO_PRICE] => 150000
[PRINT_RATIO_PRICE] => 150 000 руб.
[PRINT_DISCOUNT] => 0 руб.
[RATIO_DISCOUNT] => 0
[PRINT_RATIO_DISCOUNT] => 0 руб.
[PRINT_VAT] => 0 руб.
[RATIO_VAT] => 0
[PRINT_RATIO_VAT] => 0 руб.
[MIN_QUANTITY] => 1
)
)
[ITEM_QUANTITY_RANGES] => Array
(
[ZERO-INF] => Array
(
[HASH] => ZERO-INF
[QUANTITY_FROM] =>
[QUANTITY_TO] =>
[SORT_FROM] => 0
[SORT_TO] => INF
)
)
[ITEM_MEASURE_RATIOS] => Array
(
[0] => Array
(
[ID] => 0
[RATIO] => 1
[IS_DEFAULT] => Y
)
)
[ITEM_MEASURE] => Array
(
[ID] =>
[TITLE] => место
[~TITLE] => место
)
[ITEM_MEASURE_RATIO_SELECTED] => 0
[ITEM_QUANTITY_RANGE_SELECTED] => ZERO-INF
[ITEM_PRICE_SELECTED] => 0
[CHECK_QUANTITY] =>
[CATALOG_MEASURE_NAME] => место
[~CATALOG_MEASURE_NAME] => место
[CAN_BUY] => 1
[ITEM_PRICES_CAN_BUY] => 1
[~BUY_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=BUY&id=60990
[BUY_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=BUY&id=60990
[~ADD_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=ADD2BASKET&id=60990
[ADD_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=ADD2BASKET&id=60990
[~SUBSCRIBE_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=SUBSCRIBE_PRODUCT&id=60990
[SUBSCRIBE_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=SUBSCRIBE_PRODUCT&id=60990
[~COMPARE_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=ADD_TO_COMPARE_LIST&id=60990
[COMPARE_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=ADD_TO_COMPARE_LIST&id=60990
[~COMPARE_DELETE_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=DELETE_FROM_COMPARE_LIST&id=60990
[COMPARE_DELETE_URL] => /courses/OBI12cCAD/?ELEMENT_CODE=OBI12cCAD&action=DELETE_FROM_COMPARE_LIST&id=60990
[CATALOG_MEASURE_RATIO] => 1
[OFFER_GROUP] =>
[RATIO_PRICE] => Array
(
[VALUE] => 150000
[DISCOUNT_VALUE] => 150000
[PRINT_VALUE] => 150 000 руб.
[PRINT_DISCOUNT_VALUE] => 150 000 руб.
[DISCOUNT_DIFF] => 0
[PRINT_DISCOUNT_DIFF] => 0 руб.
[DISCOUNT_DIFF_PERCENT] => 0
[CURRENCY] => RUB
)
[MORE_PHOTO] => Array
(
[0] => Array
(
[SRC] => /bitrix/templates/.default/components/bitrix/catalog.element/course/images/no_photo.png
[WIDTH] => 150
[HEIGHT] => 150
)
)
[MORE_PHOTO_COUNT] => 1
)
)
- 18.10.2021 Москва записаться
Описание:
В данном курсе Oracle BI 12c: Create Analyses and Dashboards course для релиза 12.2.1 даются пошаговые инструкции по созданию отчетов и информационных панелей, составляющих приложения Business Intelligence. В начале курса вы настраиваете базовые аналитические отчеты для их включения в информационные панели, затем отчеты усложняются.
Слушатели научатся:
Преимущества для организации
Информация об организации станет доступной для проведения аналитики, что позволит принимать более обоснованные решения, получать своевременные, важные и детальные обзоры. Изменение отчетов и информационных панелей будет происходить более эффективно.
Изучите Oracle Hyperion Smart View for Office
Вы также научитесь использовать Oracle Hyperion Smart View for Office для включения данных и представлений Oracle BI в презентации и таблицы. По завершении курса вы получите знания и навыки по созданию мобильных приложений для BI контента c использованием пробной версии Oracle BI Mobile App Designer. Более того, при изучении процесса администрирования объектов в Каталоге презентаций Oracle BI вы освоите использование Oracle BI Briefing Books.
Цель курса:
Аудитория курса:
Введение в Oracle Business Intelligence Enterprise Edition
Введение в Oracle BI EE. Архитектура Oracle BI 12c. Особенности Oracle BI 12c.
Работа с Oracle Business Intelligence Analyses
Введение в Oracle BI Analysis Editor. Виды столбцов Oracle BI. Работа с отчетами в Oracle BI. Добавление базового форматирования. Настройка свойств отчетов. Использование усовершенствованного форматирования.
Фильтрация данных для анализа
Введение в фильтрацию и выборки. Создание, редактирование и группировка фильтров. Добавление приглашений ввода к анализу. Динамическая фильтрация. Использование сохраненных отчетов в качестве фильтров.
Выборки и группировка данных в отчетах
Создание шагов выборки. Создание групп. Создание, вычисление позиций. Создание прямых запросов отчетов к базе данных. Включение продвинутых SQL clauses в ваши отчеты.
Усовершенствованное представление в отчетах
Введение в представления, графики и редакторы. Работа с представлениями в составной разметке, Compound Layouts. Создание и редактирование графиков. Осуществление заданий по созданию обычного представления, common view tasks.
Представление результатов при помощи сводных таблиц Pivot Tables
Создание, компоновка и форматирование сводных таблиц. Использование иерархических столбцов. Сортировка в сводных таблицах. Настройка агрегации и применение итоговой суммы. Показ относительного значения позиции. Создание вычисления и представление нарастающего итога.
Работа с дополнительными представлениями в отчетах
Создание простых и продвинутых решетчатых представлений trellis views. Создание performance tile views. Работа с другими типами представлений, например Treemap и Heat Matrix. Связь представлений master-detail.
Визуализация данных на картах
Пространственные компоненты Oracle. Управление данными карт. Создание и редактирование представлений на картах. Взаимодействие с представлениями на картах. Другие приложения и точки интеграции для представления на картах.
Создание информационных панелей Бизнес Аналитики Oracle.
Создание и редактирование инфопанелей. Использование Dashboard Builder. Изучение свойств и возможностей объектов инфопанелей. Публикация страниц инфопанелей. Персональная кастомизация и использование других возможностей страниц.
Конфигурирование информационных панелей Бизнес Аналитики Oracle
Изучение видов контента информационных панелей. Включение контента в информационные панели.
Создание приглашений ввода и переменных для информационных панелей
Знакомство с переменными. Добавление названного приглашения ввода на инфопанель. Добавление приглашения ввода со скрытым названием на инфопанель. Создание дополнительной страницы приглашения ввода и настройка свойств страницы. Добавление приглашений ввода переменных на инфопанель.
Системы показателей и KPI, Key Performance Indicators
Объекты и компоненты системы показателей и управления стратегией Oracle, Oracle Scorecard and Strategy Management. Обзор ключевых показателей деятельности Key Performance Indicator (KPI). Типы документов системы показателей. Создание системы показателей и KPI. Создание документов системы показателей. Редактирование системы показателей и KPI.
Visual Analyzer, BI Ask, и Data Mashup
Создание проектов Visual Analyzer. Добавление и перегруппировка визуализации. BI Ask. Data Mashups.
Работа с контентом BI в Smart View
Работа с представлениями в Клиентах Smart View. Кастомизация данных BI в MS Office. Копирование и вставка представлений между клиентами Smart View. Вставка представлений BI в клиенты Smart View clients. Создание и публикация представлений с использованием View Designer. Объединение данных из множественных источников.
Oracle Business Intelligence Mobile
Скачивание и использование мобильного приложения Бизнес Аналитика Oracle. Навигация по приложению Oracle BI Mobile. Работа с «Избранными» и локальным контентом. Работа с контентом BI. Oracle BI Mobile Security Toolkit.
Использование Oracle Business Intelligence Delivers
Конфигурирование средств поставки и добавление профилей поставки. Добавление секции уведомлений на инфопанель. Конфигурирование Агента, Agent. Использование условий отчетов и KPI для доставки контента при помощи Агентов. Подписка на Агента.
Администрирование презентационного каталога
Обзор безопасности Бизнес Аналитики Oracle и каталога. Управление безопасностью на базе использования ролей. Понимание наследования безопасности. Настройка полномочий на объект. Настройка системных привилегий. Архивирование позиций каталога. Работа с Oracle BI Briefing Books.
Direct Database Analysis
Обзор Direct Database Analysis. Изменение полномочий Direct Database Analysis. Создание и исполнение Direct Database Analysis.
Выражения
Синтаксис и семантика SQL. Выполнение агрегатных функций. Advance Analytics Internal Logical SQL Functions. Advance Analytics External Logical SQL Functions.