内容的栏目 * @param int $category 0列表 1频道 2单页 3外链 * @return array */ function category_list($forumlist, $model = 0, $display = 0, $category = 0) { if (empty($forumlist)) return NULL; static $cache = array(); $key = $model . '-' . $display . '-' . $category; if (isset($cache[$key])) return $cache[$key]; if ($display) { foreach ($forumlist as $k => $val) { if (1 == $val['display'] && 1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } else { foreach ($forumlist as $k => $val) { if (1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } return empty($cache[$key]) ? NULL : $cache[$key]; } /** * @param $forumlist 所有版块列表不分模型 * @param int $display 0全部CMS栏目 1在首页和频道显示内容的栏目 * @param int $category 0列表 1频道 2单页 3外链 * @return array */ function category_list_show($forumlist, $display = 0, $category = 0) { if (empty($forumlist)) return NULL; static $cache = array(); $key = $display . '-' . $category; if (isset($cache[$key])) return $cache[$key]; if ($display) { foreach ($forumlist as $k => $val) { if (1 == $val['display'] && 1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } else { foreach ($forumlist as $k => $val) { if (1 == $val['type'] && $val['category'] == $category) { $cache[$key][$k] = $val; } } } return empty($cache[$key]) ? NULL : $cache[$key]; } /** * @param $forumlist 所有版块列表 * @return mixed BBS栏目数据(仅列表) 尚未开放bbs频道功能 */ function forum_list($forumlist) { if (empty($forumlist)) return array(); static $cache = array(); if (isset($cache['bbs_forum_list'])) return $cache['bbs_forum_list']; $cache['bbs_forum_list'] = array(); foreach ($forumlist as $_fid => $_forum) { if ($_forum['type']) continue; $cache['bbs_forum_list'][$_fid] = $_forum; } return $cache['bbs_forum_list']; } // 导航显示的版块 function nav_list($forumlist) { if (empty($forumlist)) return NULL; static $cache = array(); if (isset($cache['nav_list'])) return $cache['nav_list']; foreach ($forumlist as $fid => $forum) { if (0 == $forum['nav_display']) { unset($forumlist[$fid]); } } return $cache['nav_list'] = $forumlist; } ?>ssas - Size dimension to quantity MDX - Stack Overflow

你的位置：首页>programmer>ssas - Size dimension to quantity MDX - Stack Overflow

ssas - Size dimension to quantity MDX - Stack Overflow

programmeradmin2025-03-130浏览0评论

How do I make MDX show the quantity of sizes per item?

This query show what kind of sizes per item, but i want that he show me quantity per item.

Maybe need count or filter function, please help.

How i need write correct code?

select {} on 0,
{[Товары].[ItemID].[6863153]  
* [Товары].[SizeID].[SizeID]} on 1
from [Analyse]

Maybe need to create member. please help me.

How do I make MDX show the quantity of sizes per item?

This query show what kind of sizes per item, but i want that he show me quantity per item.

Maybe need count or filter function, please help.

How i need write correct code?

select {} on 0,
{[Товары].[ItemID].[6863153]  
* [Товары].[SizeID].[SizeID]} on 1
from [Analyse]

Maybe need to create member. please help me.

Share Improve this question edited Mar 7 at 16:04 Govind Parmar 21.6k7 gold badges56 silver badges89 bronze badges asked Feb 2 at 1:53 Александр Дексбах 91 bronze badge

Add a comment |

1 Answer 1

Sorted by: Reset to default 0

with 
member [measures].[sizes_count] as 
  (existing [Товары].[SizeID].[SizeID]).count
select 
  {[measures].[sizescount]} on 0,
  {[Товары].[ItemID].[6863153]} on 1
from 
  [Analyse]

与本文相关的文章

ssas - Size dimension to quantity MDX - Stack Overflow

评论列表(0)

暂无评论