hi all, in AS 2008, is it possible to create a snowflaked parent-child dimension? It appears to me that that's impossible.
thx much for any thoughts/confirmations.
View Complete Post
I am trying to build a very simple datacube without dynamic aggregations. I only have one fact table and one dimension table. The dimension is a parent child dimension. In the fact table I have a value for each leaf or non-leaf from the dimension (except
of one where I wanted to test if it shows null then). I first built the dimension which worked fine and then the cube with the only one measure with "aggregate function" = None. But when I processed the cube and went into the Browser tab and used the dimension
I was not able to the see the hierarchy. It only says "Level 2" and "Grand total" and when I double click it I get an error message "Cannot drill into a total member". I went through some posts here where it was said that the dimension cannot have "MemberWithData"
= NonLeafDataHidden which I had, so I changed it to visible. I also read that there cannot be a "Calculate" calculation when using no aggretion so I deleted that. Nothing changed the fact that I did not have the hierarchy in the dimension and didnt see any
values from my fact table.
I think I need to something with the Calculation but i dont know what. I would be much appreciated if you could help me.
Thanks for your help,
I was wondering (even this might a very bad idea from a logical and performance perspective) if it is possible to use unary operator and custom member formula simultaneously? Until now I have used unary operator but now some new calculation can't be expressed
using unary operator. The idea is just to add the new members calculation to custom member formulas. Is it possible to make cohabitate both. If I had to switch all unary operators to customer member formulas what would be the equivalent expression for +, -
thanks for your answer
I have a problem with a reporting services 2005 report.
The data source is OLEDB for OLAP 9. ÃÂ The report contains all the members of a parent child dimension. An example of the implementation is defined in the post following the forum msdn: Http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=138549&SiteID=1. ÃÂ ÃÂ ÃÂ The report works fine in web. The problem is when the report is exported as Excel, the groups disappeared and the entire dimension is ragged down.ÃÂ Normally toggled groups in reporting services are exported to Excel with the appearance '+' or '-' on the
I have a parent-child hiearchy where, when I browse it, the top most element is a sibling of the first child instead of the parent of the first child. I seemed to have narrowed down the behavior to the fact that the top most element has an id of 0 instead
of 1. When the top most element id is 1, I don't get this behavior.
Is there an attribute property that I may have misconfigured to cause this behavior?
Consider the following table:
ItemID ParentItemID Description
-------- ------------ -----------
0 null Top Node
1 0 Child Node
2 1 Grandchild node
I get the following in the Browser tab for the dimension
- All Test Nodes
- Child Node
- Grandchild Node
- Top Node
Notice that the "Top Node" is
We are trying to build some finanical reports (Balance Sheet, Income Statement, etc) in reporting services using Analysis Services as a data source. The problem we are running into is more of a formatting issue around the use of custom headers.
We want to have the ability to do the following:
Interest Income (as a header)
Total Interest Income (rollup of children above)
Interest Expense (as a header)
Total Interest Expense (rollup of children above)
Provision for loan losses (single line item, no group needed)
Getting the parent to appear after the child is pretty simple by using the hierarchize function. The problem is getting the parent as a header to appear. The crux is that we only want to use certain levels (not every single level) in the
parent child hierarchy for doing a header. For example, above, Interest Income and Interest Expese would have a header, whereas Provision for loan losses would not.
This is pretty common formatting features for financial reports, plus its very common to use a parent child for Chart of Accounts, thus somebody has had to have run into this in the past.
I'm using cssfriendly control adapter for menu. My asp.net menu control's datasource is a sitemap file I'm using which contains all the urls.
I have the following questions:
MSDN Magazine May 2004
MSDN Magazine July 2003
When I open two modalpopups, one over another, there is unexpected order.
After click on "Open Parent Panel", and click on "Open Child Panel",
Child Panel (newone) is under the Parent.
Uploaded with ImageShack.us
What should I do to get it in "normal order"?
The code is: