TM1 Function, VIEW (Excel)
VIEW sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker. When Slicing a view in Perspectives or exporting to a Custom Report in PAX, the VIEW function is used to optimise the report. In the VIEW function, title dimension is referenced to an element, while the dimensions in the row and column axis are defined as “!” to include all elements.
Use in Excel.
Syntax
VIEW(TM1ServerName:Cube, Element 1, Element 2,… , , "!","!", Element n)
TM1ServerName = Name of the TM1 Server
Cube = Name of the Cube
Element 1 and Element 2 = Name of the title dimension elements
“!” = refers to row or column dimensions to include all elements
Demo
Export the default view from the Product Scorecard cube as a Custom Report and show how the VIEW function is put together.
Website: http://edu.cubewise.com
Reach out to us at [email protected]
Смотрите видео TM1 Function, VIEW (Excel) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Cubewise 23 Февраль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,567 раз и оно понравилось 3 людям.