What is the formula to bring the current last date from period hierarchy

Advertisement
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.
Advertisement

Replay

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.

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.

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'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

TS1424 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 you

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

HT201250 Circle and cross through iTunes icon afte the seagate hard drive replaced and restored data from time machine backup.

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(vecto​r signal analyzer ) to measure such as RF frequency or power on the instrument​? Thanks

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

What is the Best way To Copy and paste data from 1 book to another

 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.

What is the best way to load and convert data from a flat file?

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

What's the RFC name for BPS to transfer data from one Plan-Area to another?

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

What is the best wayt to copy tables with data from development to Prod?

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

The best way to move 2TB of data from Win to Mac

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

Please help! My ipod touch 4 screen has gone completely white, what should I do to bring the screen back to normal?

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

A search for "NO NO NO. i WANT my TITLE bar in the window" STILL brings the same 14 suggested answers. NOT GOOD PEOPLE. I need an answer. How do I get it back???

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

How to retrieve the data from MDM hierarchy table using MDM Java API

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 for automatically entering todays date into Numbers.  In Quattro, it was '@today', but I cannot find it in numbers.  Thx

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

Enter Function in  the Formulas assistant - BOFC 7.5

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

How to bring the max value add 1 in creation mode

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

Formula to deviate the needle of 3dguage in sap XMII

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

How to remove the 0 that is added to the formula result

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

Pagnation by the first letter of the last name

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