{"id":193,"date":"2011-05-02T19:03:00","date_gmt":"2011-05-02T19:03:00","guid":{"rendered":"http:\/\/turtlellc.com\/index.php\/viewing-data-in-a-nw-appset\/"},"modified":"2011-05-02T19:03:00","modified_gmt":"2011-05-02T19:03:00","slug":"viewing-data-in-a-nw-appset","status":"publish","type":"post","link":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/","title":{"rendered":"Viewing Data in a NW AppSet"},"content":{"rendered":"<p><span style=\"font-family:trebuchet ms;\">Often I need<\/span> to know where data is when testing after an upgrade or install. For the NW version do the following:<\/p>\n<ol>\n<li>Login to SAP GUI<\/li>\n<li>Start transaction RSA1<\/li>\n<li>If prompted, decide whether to view or not view the documentation<\/li>\n<li>In the Modeling pane, click InfoProvider<\/li>\n<li>In the large pane on the right, expand Business Planning and Consolidation<\/li>\n<li>Expand your AppSet<\/li>\n<li>Right click on your Application, then select Display Data<\/li>\n<li>If an information dialog appears about too many characteristics, click the green check<\/li>\n<\/ol>\n<p>At this point a dialog appears with all the dimensions and their properties. So for example, the P_Activity dimension shows 4 rows:<\/p>\n<ol>\n<li>[ ] [ ] CALC[P_ACTIVITY]<\/li>\n<li>[ ] [x] CALC[P_ACTIVITY]<\/li>\n<li>[ ] [ ] P_ACTIVITY<\/li>\n<li>[ ] [x] P_ACTIVITY<\/li>\n<\/ol>\n<p>Notice there are white check boxes and greyed out check boxes. The grey boxes that are checked indicate the ID for the member, the non checked contain the name. So check the white check box like this to get ID and Name:<\/p>\n<ol>\n<li>[ ] [ ] CALC[P_ACTIVITY]<\/li>\n<li>[ ] [x] CALC[P_ACTIVITY]<\/li>\n<li>[x] [ ] P_ACTIVITY<\/li>\n<li>[x] [x] P_ACTIVITY<\/li>\n<\/ol>\n<p>Do this for every dimension you want to view with your results. Notice the SignedData row at the end, this is the actual value column. Then:<\/p>\n<ol>\n<li>Click the green check.<\/li>\n<li>Clicking the Fld Selectn for Output button<\/li>\n<li>Click the Select All button<\/li>\n<li> Click the Clock with a green check button<\/li>\n<li>You return to the previous screen<\/li>\n<li> Click the Clock with a green check button again<\/li>\n<li>Your data displays<\/li>\n<\/ol>\n<p>Once I know where data is located I can run reports in the Excel client.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often I need to know where data is when testing after an upgrade or install. For the NW version do the following: Login to SAP GUI Start transaction RSA1 If prompted, decide whether to view or not view the documentation In the Modeling pane, click InfoProvider In the large pane on the right, expand Business &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Viewing Data in a NW AppSet&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[4,15],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry","category-bpc","category-nw"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Viewing Data in a NW AppSet - Turtle Works<\/title>\n<meta name=\"description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve Viewing Data in a NW AppSet - Turtle Works\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Viewing Data in a NW AppSet - Turtle Works\" \/>\n<meta property=\"og:description\" content=\"A knowledge base written by Turtle Works LLC to help you achieve Viewing Data in a NW AppSet - Turtle Works\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/\" \/>\n<meta property=\"og:site_name\" content=\"Turtle Works\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-02T19:03:00+00:00\" \/>\n<meta name=\"author\" content=\"josef.wainz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"josef.wainz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/\"},\"author\":{\"name\":\"josef.wainz\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\"},\"headline\":\"Viewing Data in a NW AppSet\",\"datePublished\":\"2011-05-02T19:03:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/\"},\"wordCount\":262,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"articleSection\":[\"BPC\",\"NW\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/\",\"name\":\"Viewing Data in a NW AppSet - Turtle Works\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\"},\"datePublished\":\"2011-05-02T19:03:00+00:00\",\"description\":\"A knowledge base written by Turtle Works LLC to help you achieve Viewing Data in a NW AppSet - Turtle Works\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/viewing-data-in-a-nw-appset\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Viewing Data in a NW AppSet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#website\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"name\":\"Turtle Works\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#organization\",\"name\":\"Turtle Works\",\"url\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"contentUrl\":\"http:\\\/\\\/www.turtle.works\\\/knowledge\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/cropped-TurtleWorks.png\",\"width\":625,\"height\":250,\"caption\":\"Turtle Works\"},\"image\":{\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.turtle.works\\\/knowledge\\\/#\\\/schema\\\/person\\\/cb79278290029b781485a7b61b9b9a0b\",\"name\":\"josef.wainz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g\",\"caption\":\"josef.wainz\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Viewing Data in a NW AppSet - Turtle Works","description":"A knowledge base written by Turtle Works LLC to help you achieve Viewing Data in a NW AppSet - Turtle Works","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/","og_locale":"en_US","og_type":"article","og_title":"Viewing Data in a NW AppSet - Turtle Works","og_description":"A knowledge base written by Turtle Works LLC to help you achieve Viewing Data in a NW AppSet - Turtle Works","og_url":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/","og_site_name":"Turtle Works","article_published_time":"2011-05-02T19:03:00+00:00","author":"josef.wainz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"josef.wainz","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/#article","isPartOf":{"@id":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/"},"author":{"name":"josef.wainz","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b"},"headline":"Viewing Data in a NW AppSet","datePublished":"2011-05-02T19:03:00+00:00","mainEntityOfPage":{"@id":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/"},"wordCount":262,"commentCount":0,"publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"articleSection":["BPC","NW"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/","url":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/","name":"Viewing Data in a NW AppSet - Turtle Works","isPartOf":{"@id":"https:\/\/www.turtle.works\/knowledge\/#website"},"datePublished":"2011-05-02T19:03:00+00:00","description":"A knowledge base written by Turtle Works LLC to help you achieve Viewing Data in a NW AppSet - Turtle Works","breadcrumb":{"@id":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.turtle.works\/knowledge\/viewing-data-in-a-nw-appset\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.turtle.works\/knowledge\/"},{"@type":"ListItem","position":2,"name":"Viewing Data in a NW AppSet"}]},{"@type":"WebSite","@id":"https:\/\/www.turtle.works\/knowledge\/#website","url":"https:\/\/www.turtle.works\/knowledge\/","name":"Turtle Works","description":"","publisher":{"@id":"https:\/\/www.turtle.works\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.turtle.works\/knowledge\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.turtle.works\/knowledge\/#organization","name":"Turtle Works","url":"https:\/\/www.turtle.works\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/","url":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","contentUrl":"http:\/\/www.turtle.works\/knowledge\/wp-content\/uploads\/2020\/07\/cropped-TurtleWorks.png","width":625,"height":250,"caption":"Turtle Works"},"image":{"@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.turtle.works\/knowledge\/#\/schema\/person\/cb79278290029b781485a7b61b9b9a0b","name":"josef.wainz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7c48ebcd2ee23a7db62291036c5ff0cd06cf9f7595838f86ecb17784c9af59c?s=96&d=mm&r=g","caption":"josef.wainz"}}]}},"_links":{"self":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":0,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.turtle.works\/knowledge\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}