{"id":15347,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupuyeozelligi\/"},"modified":"2021-02-25T16:24:47","modified_gmt":"2021-02-25T16:24:47","slug":"cubememberproperty","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/","title":{"rendered":"K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, kullan\u0131c\u0131lar\u0131n veri analizini kolayla\u015ft\u0131rmak i\u00e7in \u00e7e\u015fitli ileri d\u00fczey i\u015flevler sunar. Bu i\u015flevlerden biri olan CUBEMEMBERPROPERTY, T\u00fcrk\u00e7ede “K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130” olarak bilinir ve bir k\u00fcpteki belirli bir \u00fcyenin \u00f6zelliklerini almak i\u00e7in kullan\u0131l\u0131r. Bu i\u015flevin parametreleri ve kullan\u0131m\u0131 hakk\u0131nda daha detayl\u0131 bilgi edinelim.<\/p>\n

K\u00fcp \u00dcyesi \u00d6zelli\u011fi Fonksiyonunun S\u00f6zdizimi ve \u00d6rnek Kullan\u0131m\u0131<\/h2>\n

K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130 fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130(ba\u011flant\u0131, \u00fcye_ifadesi, \u00f6zellik_ad\u0131) <\/code><\/pre>\n
    \n
  • ba\u011flant\u0131<\/strong>: Analiz servisleri ile ba\u011flant\u0131y\u0131 temsil eden bir dizedir. \u00d6rne\u011fin, bir Excel dosyas\u0131ndaki bir PivotTable ba\u011flant\u0131s\u0131n\u0131 kullanabilirsiniz.<\/li>\n
  • \u00fcye_ifadesi<\/strong>: \u00d6zelli\u011fi sorgulanan k\u00fcp \u00fcyesini tan\u0131mlayan ifadedir. Genellikle \u00fcyenin ad\u0131n\u0131 veya bir tan\u0131mlay\u0131c\u0131y\u0131 i\u00e7erir.<\/li>\n
  • \u00f6zellik_ad\u0131<\/strong>: Al\u0131nmak istenen \u00f6zelli\u011fin ad\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u0130\u015fte basit bir \u00f6rnek:<\/p>\n
    =K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130(\"SalesCube\"; \"[\u00dcr\u00fcn].[\u00dcr\u00fcnKategorisi].&[123]\"; \"\u00dcr\u00fcn ad\u0131\") <\/code><\/pre>\n
    Bu \u00f6rnekte, “SalesCube” adl\u0131 bir k\u00fcpten, ID’si 123 olan \u00fcr\u00fcn kategorisine ait “\u00dcr\u00fcn ad\u0131” \u00f6zelli\u011fi \u00e7ekilmektedir. Burada “SalesCube”, analiz servisinin ad\u0131n\u0131, “[\u00dcr\u00fcn].[\u00dcr\u00fcnKategorisi].&[123]” ifadesi ise belirli bir \u00fcr\u00fcn kategorisini tan\u0131mlamaktad\u0131r.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    \u00dcr\u00fcn Bilgilerinin Y\u00f6netimi<\/h2>\n
    Bir \u015firketin \u00fcr\u00fcn veri taban\u0131nda \u00e7al\u0131\u015f\u0131ld\u0131\u011f\u0131n\u0131 d\u00fc\u015f\u00fcnelim ve her \u00fcr\u00fcn\u00fcn \u00e7e\u015fitli \u00f6zelliklerine eri\u015fim gereksinimi oldu\u011funu varsayal\u0131m. Belirli bir \u00fcr\u00fcn\u00fcn model numaras\u0131 veya \u00fcretim y\u0131l\u0131 gibi \u00f6zel bilgiler h\u0131zla sorgulanabilir. K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130 fonksiyonu bu t\u00fcr durumlar i\u00e7in idealdir:<\/p>\n
    =K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130(\"\u00dcr\u00fcnVeriTaban\u0131\"; \"[\u00dcr\u00fcn].[\u00dcr\u00fcnID].&[456]\"; \"Model Numaras\u0131\") <\/code><\/pre>\n
    Bu komut ile “\u00dcr\u00fcnVeriTaban\u0131” adl\u0131 k\u00fcpten, ID’si 456 olan \u00fcr\u00fcn\u00fcn “Model Numaras\u0131” \u00f6zelli\u011fi elde edilir.<\/p>\n
    Finansal Raporlama ve Analizi<\/h2>\n
    Finansal veriler \u00fczerine \u00e7al\u0131\u015fan bir analist iseniz, belirli bir mali d\u00f6nem i\u00e7in \u00f6nemli finansal g\u00f6stergeleri incelemek isteyebilirsiniz. \u00d6rne\u011fin, belirli bir \u00e7eyre\u011fin sat\u0131\u015f rakamlar\u0131 veya kar marjlar\u0131 gibi detaylar ele al\u0131nabilir. \u0130lgili fonksiyonu \u015fu \u015fekilde kullanabilirsiniz:<\/p>\n
    =K\u00dcP\u00dcYE\u00d6ZELL\u0130\u0127\u0130(\"FinansRaporlama\"; \"[Zaman].[D\u00f6nem].&[2023Q1]\"; \"Toplam Sat\u0131\u015flar\") <\/code><\/pre>\n
    Bu \u00f6rnekte, “FinansRaporlama” adl\u0131 k\u00fcpten 2023 y\u0131l\u0131n\u0131n ilk \u00e7eyre\u011fine ait “Toplam Sat\u0131\u015flar” bilgisi elde edilir.<\/p>\n
    Bu t\u00fcr fonksiyon kullan\u0131mlar\u0131, kurumsal seviyede veri analizi yaparken zaman\u0131 verimli bir \u015fekilde kullanman\u0131z\u0131 ve ihtiyac\u0131n\u0131z olan bilgilere kolayca ula\u015fman\u0131z\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    K\u00fcpteki bir \u00fcyenin \u00f6zelli\u011finin de\u011ferini verir K\u00fcp i\u00e7inde \u00fcye ad\u0131n\u0131n varl\u0131\u011f\u0131n\u0131 do\u011frulamak ve bu \u00fcyenin belli \u00f6zelliklerini getirmek i\u00e7in kullan\u0131l\u0131r<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[587],"tags":[],"class_list":["post-15347","post","type-post","status-publish","format-standard","hentry","category-kup"],"acf":[],"yoast_head":"\nExcel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:24:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/\",\"name\":\"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:24:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"K\u00fcp\",\"item\":\"https:\/\/functiontranslator.com\/tr\/kup\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/","url":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/","name":"Excel'de CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:24:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CUBEMEMBERPROPERTY (K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/cubememberproperty\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/cubememberproperty\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"K\u00fcp","item":"https:\/\/functiontranslator.com\/tr\/kup\/"},{"@type":"ListItem","position":3,"name":"K\u00dcP\u00dcYE\u00d6ZELL\u0130\u011e\u0130"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15347"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15347\/revisions"}],"predecessor-version":[{"id":27046,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15347\/revisions\/27046"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}