我创建了一个多瑙河行动,为平息地点(历史书籍实例)开放 go光图,现在我试图建造一个多瑙河行动,为尺寸产品开放网页。
这就是我迄今为止所做的事情:
目标:<代码>DimProduct. [Product>
行动表述:http://www..../"+DimProduct.[Product ID].CurrentMember.Member_Caption
如你所知,用户按产品描述浏览分解,但网站使用的是产品识别。
根据这项行动,DimProduct. [Product ID].Current Members. Members_Caption/ is translation as “all”,因此,最后表述变成了http://www..../all",而不是http://www..../134"(134 in an example ofproduct ID)。
How can I grab the product ID in a case like this? Any help appreciated.
拉脱维亚
Part problem is the "potential" differences in granularity between [Dim Product].[Product Description] and [Dim Product].[Product]. In the AdventureWorks data model, there is a 1-many relationship between these two...
因此,在我上面的屏幕上,如果用户右翼电池A10,你想要使用哪一个产品识别器? 页: 1
[Dim Product].[Product ID].CurrentMember.Member_Caption
......只是说,“使用目前的东西”。 因此,你想要尝试像......这样的东西。
[Dim Product].[Product ID].FirstChild.Member_Caption
采用第一 孩子们说,“在名单中首先考虑并使用”。
另一个问题是,你可能需要使用“成员——Key”财产,而不是“成员——Caption”,但这取决于如何确定你的产品层面。 这里有一些关于不同成员的特性。
I have a many-to-many dimension in my cube (next to other regular dimensions). When I want to exclude fact rows in my row count measure, I usually do something like the following in MDX SELECT [...
我是SSAS的一个新奇,具有一些理论知识。
These are really hard to describe without going in-depth into the data structure, i ll try to keep it as short as possible while giving as much info as I can. I have a measure which is a monetary ...
I have a table with a list of contract line items in the form of CREATE TABLE contracts_lines ( contract_id integer, product_id integer, contract_line_start datetime, contract_line_end ...
Proficient with SQL but new to MDX, I am having trouble getting my head around this: I have a fact table that contains snapshots of account balances monthly. I need to roll up the balances as a semi-...
In a parent-child dimension in SSAS, the datamember is automatically named the same as the parent. E.g. Division X Risk Register Division X Risk Register Department A Risk Register Department B ...
I have the following query that gives me an extract (I am putting this into a CSV from my cube). I want to show the Total of all NRx in a column as the first column NRx and the rest of the NRx ...
First some background: I have the typical Date dimension (similar to the one in the Adventure Works cube) and an Account dimension. In my fact table I have daily transaction amounts for the accounts. ...