What is the formula to bring the current last date from period hierarchy
Hi, Iam working on Hyperion financial Reporting.i have created a grid with 2 dimensions(entity and period).My requirement is that the current last date of the period hierarchy should be displayed automatically in the header when the report is run.what formula should i write in the textbox to bring the current last date.Moreover i dont want to create a prompt for the period dimension. Kindly help me on this. thanks in advance.
Thanks for all your replies..
My actual requirement is that I have a period dimension with year,month and week as members.I dont want to set period as a UserPOV or a prompt.but i want the last date of current week of the period diemnsion to get automatically displayed in the text box which is placed on the header when the report is run.Period dimension is not used anywhere else in the report.I've tried using another grid for the period and i've hidden it.but what formula should I use to to display the last date of the week on the header.I tried using the function Bottomofhierarchy but it wasn't helpful..
Please help me on this.
Hi, I mistakenly set up iPad3 using currently backup data from iPhone4, instead of do it as new iPad Now the feature of iPad Cover Lock/Unlock is missing and iTunes can't detect the iPad3 Anyone having clue how to fix this? Thanks.ok, here is the sol
I'm worried about what will happen if I delete my recent backup data from the phone I still own? Will I lose any progress in games that was saved in the backup? I have an iPhone 4S and I keep getting those irritating notifications that tell me I need
Hello I have a problem in my phone The email request with Psoard forgotten I bought the phone by bringing the two years I have Vetorh with carton I want to help you thank youHi mylenebar! Here is an article that will help you remove the desired photo
Circle and cross through iTunes icon: had the seagate hard drive replaced and restored data from time machine backup. Why does the iTunes icon have a circle and cross through it? As though incomplete? tried everything and still Circle and cross throu
I'm new to the LabView. How do I pass data from VI configured using Serial (CMTS using CLI commands to set Parameters ) to VI configured using GPIB(vector signal analyzer ) to measure such as RF frequency or power on the instrument? I just want to se
I have 18 sheets in 5 different books that I want to extract data from specific cells. What is the best way to do this? Example: 1 sheet is called Numbers E-O1 data in 13:WXYZ. The data updates and moves up 1 row every time I enter a new number.
Hi, I want to load data from a flat file, convert dates, numbers and some fields with custom logic (e.g. 0,1 into N,Y) to the correct format. The rows where all to_number, to_date and custom conversions succeed should go into table STG_OK. If some co
I created a role for BPS planner.This include all authorization except the RFC authorization for transfering data from one plan-area to another.However, even I set the '*' to the RFC name. Am I missing something? Any suggestion is appreciated. Best r
Dear all, We have Oracle tables with data in a development server, I would like to know if there is any 'easy' and 'direct' way to copy them to the production server. As I think import and export would be the best way. Any other althernatives? Thanks
Hello, what is the best way me to move 2TB (multiple files) data from windows to Mac? I think that over the LAN, even using crossover cable connecting 1GB NICs would be painfully long. (Windows disk is quite fragmented) If I put windows (ntfs partiti
Can any body help me. I really don't want to pay for a new one or a replacement one.Apple stores have a technician called a Genius. You either call the local store to make an appointment or go tothe store's webpage. The Genius will help yu troublesh
And, it is a bit tough to get the "Help > Troubleshooting Information" when the MENU is MISSING. An upgrade isn't an upgrade if it takes you down, even one notch. version 4 now. -And, it is a bit tough to get the "Help > Troubleshooti
Hi, I had a hierarchy table in MDM. This table had some column say x. I want to retrieve the values of this x column and need to show them in a drop down using MDM Java API. Can anyone help me to solve this? Regards VallabhaneniHi, Here is your code.
What is the formula to automatically enter 'current date' into spreadsheet? In Quattro, it was '@today', but I cannot find it in the Numbers spreadsheet. Thx201, Do you want it to update or always show the date when entered? For updates, use the TO
Hello There is a function name ENTER in the 7.5 BFC version, in the formula assistant, and I want to know what it's doing. I've tried to find the definition in the guideline and was not able to find it. Tx for your help Regards ChristineHello, here i
Dear sir: I have ADF form and when I press on create Button I want on one of the field to bring the maximum number +1, I don't want to use DBSequance because the user should decide if he want the default number or enter new one, also I need if the us
i m getting confused about the formula to deviate the needle position.i found lot.but i dont know which one suits well.hi ramesh, try this "rotate(" & (20 + 320 * (value - minrange) / (maxrange - minrange)) & " 150 150)" a
Hi, I have a formula field. i placed the formula field in the group footer. zero (0) is added to the formula result. if the formula result is 8 then i am getting 0.00 and 8 as data when i select the browse field data of that field . how to rem
Hello, I have a report that is Grouped by Cities and then Last Name. So New York is the city and then all the customers are listed below in Ascending order starting with the first customer who last name begins with the letter A and continues thru to