{"id":9292,"date":"2021-02-08T08:00:31","date_gmt":"2021-02-08T07:00:31","guid":{"rendered":"http:\/\/192.168.20.3\/?p=9292"},"modified":"2024-12-11T12:23:14","modified_gmt":"2024-12-11T11:23:14","slug":"uso-de-queries-como-infoproviders-en-sap-bw","status":"publish","type":"post","link":"https:\/\/orekait.com\/es\/uso-de-queries-como-infoproviders-en-sap-bw\/","title":{"rendered":"Uso de queries como InfoProviders en SAP BW<br><span class=\"font-300\"><\/span>"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221;][et_pb_row admin_label=&#8221;Imagen principal&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_image src=&#8221;https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/Uso-de-queries-como-InfoProviders-en-SAP-BW.png&#8221; alt=&#8221;cloud-public&#8221; title_text=&#8221;Uso-de-queries-como-InfoProviders-en-SAP-BW&#8221; admin_label=&#8221;Imagen principal&#8221; module_class=&#8221;post-img&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Cuerpo&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text admin_label=&#8221;Texto&#8221; _builder_version=&#8221;4.25.2&#8243; header_2_font_size=&#8221;24px&#8221; header_3_font_size=&#8221;20px&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; width=&#8221;%22630%22&#8243; height=&#8221;%22307%22&#8243; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; content__hover_enabled=&#8221;off|desktop&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<p>Seguro que alguna vez has necesitado utilizar los datos guardados en un InfoProvider (ODS, cubo\u2026) como origen del dato para rellenar otro InfoProvider, pero la estructura de los datos no era la m\u00e1s amigable o requer\u00edas de un filtro complejo para no tener que cargar todo el contenido que tra\u00eda \u00e9ste, mientras ten\u00edas una query donde ya ten\u00edas el dato tal y como te gustar\u00eda utilizarlo, o con una query pod\u00edas solventar f\u00e1cilmente este problema, sin complicarte demasiado filtrando un DTP o utilizando complicadas rutinas en una transformaci\u00f3n.<\/p>\n<p>Pues\u2026 \u00a1est\u00e1s de suerte! Porque es posible utilizar queries como InfoSitio. Basta con aplicar una ligera configuraci\u00f3n sobre la query.<\/p>\n<h2><strong>\u00bfC\u00f3mo puedo hacer esto?<\/strong><\/h2>\n<p>Primero, necesitas configurar la query para poder utilizarla como infoSitio, para esto, en la transacci\u00f3n RSRT.<\/p>\n<div class=\"wp-block-image\" style=\"text-align: center;\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9301 size-full\" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image001.png\" alt=\"\" width=\"737\" height=\"109\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image001.png 737w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image001-480x71.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 737px, 100vw\" \/><br \/><figcaption><em>Monitor de query<\/em><\/figcaption><\/figure>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Aqu\u00ed, en las propiedades de la consulta, podemos marcar un check para habilitar esta funci\u00f3n. Eso s\u00ed, como para los InfoSitios, requiere que el nombre t\u00e9cnico de la consulta sea como m\u00e1ximo de 9 caracteres, por lo que puedes hacer una copia de la query que vas a utilizar para este prop\u00f3sito.<\/p>\n<div class=\"wp-block-image\" style=\"text-align: center;\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9305 size-full\" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image003.png\" alt=\"\" width=\"657\" height=\"162\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image003.png 657w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image003-480x118.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 657px, 100vw\" \/><br \/><figcaption><em>Operations in BW\/HANA<\/em><\/figcaption><\/figure>\n<\/div>\n<p>&nbsp;<\/p>\n<p>En esta pantalla se pueden configurar m\u00e1s opciones relacionadas con este tema, pero en este art\u00edculo no entraremos m\u00e1s que en la configuraci\u00f3n m\u00e1s b\u00e1sica.<\/p>\n<p>En esta transacci\u00f3n (RSRT) tambi\u00e9n puedes ejecutar la query para observar el dato que contendr\u00e1 el InfoSitio generado.<\/p>\n<h4><strong>\u00bfY ahora qu\u00e9?<\/strong><\/h4>\n<p>Tras activar esta configuraci\u00f3n, el InfoSitio aparecer\u00e1 en la transacci\u00f3n RSA1 junto al resto.<\/p>\n<div class=\"wp-block-image\" style=\"text-align: center;\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9309 size-full\" src=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image005.png\" alt=\"\" width=\"400\" height=\"126\" srcset=\"https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image005.png 400w, https:\/\/orekait.com\/wp-content\/uploads\/2021\/02\/image005-300x95.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><br \/><figcaption><em>Resultado de b\u00fasqueda transacci\u00f3n<\/em><\/figcaption><\/figure>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Ahora puedes crear transformaciones a partir de este objeto como si se tratase de un ODS normal, incluyendo crear rutinas para perfeccionar m\u00e1s el dato a tu gusto.<\/p>\n<p>Tambi\u00e9n configurar filtros adicionales en el propio DTP.<\/p>\n<p>Cada vez que se ejecute el DTP se obtendr\u00e1 una foto del dato mostrado en la query y ser\u00e1 esa informaci\u00f3n la que se subir\u00e1 al destino de la transformaci\u00f3n.<\/p>\n<p>A la hora de consultar las propiedades del InfoSitio, te devolver\u00e1 a las propiedades de la query en la transacci\u00f3n RSRT.<\/p>\n<p>En este art\u00edculo hemos comprobado que, de manera sencilla, podemos aprovechar al m\u00e1ximo las capacidades de una query sin necesidad de realizar complicadas rutinas o utilizar APDs. Si te ha sido \u00fatil o te ha surgido alguna duda, recuerda que puedes contactar con nosotros a trav\u00e9s de los comentarios.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;M\u00e1s informaci\u00f3n&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<\/p>\n<p class=\"morado\">M\u00e1s informaci\u00f3n:<\/p>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/orekait.com\/es\/area-analitica-negocio&#8221; button_text=&#8221;M\u00e1s informaci\u00f3n&#8221; module_class=&#8221;entrada-btn&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_color=&#8221;#8156EA&#8221; button_bg_color=&#8221;RGBA(255,255,255,0)&#8221; button_border_color=&#8221;#8156EA&#8221; button_border_radius=&#8221;30px&#8221; button_font=&#8221;Plus Jakarta Sans|600|||||||&#8221; button_icon=&#8221;&#x24;||divi||400&#8243; button_icon_color=&#8221;#8156EA&#8221; button_on_hover=&#8221;off&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; button_text_color__hover_enabled=&#8221;on|desktop&#8221; button_text_color__hover=&#8221;#8156EA&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;#8156EA&#8221; button_bg_enable_color__hover=&#8221;on&#8221; button_icon_color__hover_enabled=&#8221;on|hover&#8221; button_icon_color__hover=&#8221;#ffffff&#8221; url_new_window=&#8221;on&#8221; sticky_enabled=&#8221;0&#8243;][\/et_pb_button][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||40px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row use_custom_gutter=&#8221;on&#8221; admin_label=&#8221;Noticias relacionadas titulo&#8221; module_id=&#8221;fondo-articulos&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f7f7f7&#8243; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; custom_margin=&#8221;||40px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][et_pb_heading title=&#8221;Quizas te pueda interesar&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; title_level=&#8221;h2&#8243; title_text_align=&#8221;center&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_heading][et_pb_divider show_divider=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||30px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_divider][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;Noticias relacionadas&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; custom_margin=&#8221;-150px||||false|false&#8221; custom_margin_tablet=&#8221;0px||||false|false&#8221; custom_margin_phone=&#8221;0px||||false|false&#8221; custom_margin_last_edited=&#8221;on|desktop&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_blog fullwidth=&#8221;off&#8221; posts_number=&#8221;3&#8243; include_categories=&#8221;current&#8221; show_author=&#8221;off&#8221; show_date=&#8221;off&#8221; show_pagination=&#8221;off&#8221; _builder_version=&#8221;4.25.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_blog][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seguro que alguna vez has necesitado utilizar los datos guardados en un InfoProvider (ODS, cubo\u2026) como origen del dato para rellenar otro InfoProvider, pero la estructura de los datos no era la m\u00e1s amigable o requer\u00edas de un filtro complejo para no tener que cargar todo el contenido que tra\u00eda \u00e9ste, mientras ten\u00edas una query [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":9294,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"Lorem ipsum dolor sit amet consectetur adipiscing elit congue montes, imperdiet taciti erat elementum fermentum sem ante ultrices ridiculus, sagittis sociis egestas quisque ac semper quis odio. Aenean hendrerit ac metus dis nascetur aliquet mollis integer, rutrum vel laoreet posuere proin sagittis luctus est, tempus duis nisl ultrices parturient tempor praesent. Dignissim curabitur nascetur pellentesque augue fringilla pulvinar eros, tempus fames vehicula maecenas cubilia id, rutrum euismod integer ut scelerisque mus.\r\n\r\nVivamus auctor odio aenean rhoncus natoque dictum purus, volutpat pellentesque laoreet ridiculus consequat nisi varius euismod, augue platea convallis curae magnis taciti. Imperdiet nibh curabitur quisque orci consequat aenean pellentesque, cubilia duis senectus felis sed posuere tortor, magnis enim diam a odio sociis. Enim tellus nisl nec molestie augue luctus tempor habitant, nunc dictumst phasellus volutpat sem facilisis taciti, habitasse laoreet at turpis vel fermentum vulputate.","_et_gb_content_width":"","footnotes":""},"categories":[43],"tags":[],"class_list":["post-9292","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics"],"_links":{"self":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts\/9292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/comments?post=9292"}],"version-history":[{"count":7,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts\/9292\/revisions"}],"predecessor-version":[{"id":21718,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/posts\/9292\/revisions\/21718"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/media\/9294"}],"wp:attachment":[{"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/media?parent=9292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/categories?post=9292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orekait.com\/es\/wp-json\/wp\/v2\/tags?post=9292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}