ContributionsMost RecentMost LikesSolutionsRe: Consolidated Excel Report into Books Hello Shiva, You cannot pull the consolidated excel file into a book, but you can pull the Cube views used to create consolidated excel file into the report books and create a consolidated report bo...Re: Data import from Stage to Cube Hello, Check 1: Please check if suppression is enabled in rows and cols. If so, please make it "False" and check if you see rest of all the lines of data. Attached screen shot for your reference. ...Re: Quarterly / yearly values only show the amount of the last month/quarter Hello, Please include view dimension in your member filter and remove it from the POV pane as your report uses two different view members. For the first four columns, include V#QTD to get the quarte...Re: Quarterly / yearly values only show the amount of the last month/quarter Hello, In order to get each month's value, you can try Q1.Base, Q2.Base, Q3.Base and Q4.Base. In order to get the sum of all quarters, you have use V#YTD for the year - T#Year, V#YTD. V#QTD will on...Re: Cube View Math Division Hello, Could you please send me the actual calculation like in math terms so that I can tell you whether it is possible? In the divide function, the first term is the numerator, and the second term...Re: Cube View Math Division Hello, Could you please provide the formula (sample formula with the sample rows)? Will be able to help you. The error message says that the formula might be missing a parenthesis. This can be fix...Re: Introduce a Blank row in-between members in Tree Expansion Thank you Peter! I am aware of this method of introducing blank row. What I want to achieve is when I am using .Tree to display the hierarchy, will I be able to introduce blank rows in-between the hi...Introduce a Blank row in-between members in Tree Expansion Hello All, I have a reporting requirement, where I need to introduce an empty row between two Sub-Business units. These business hierarchies are displayed using .Tree expansion. In between the Tree ...
