in the prompt screen the user will be prompted to choose either of the report period
NAM Fiscal Calendar
2 Custom Time Period
When NAM fiscal calendar is selected then again weekly,monthly,quarterly should be listed.
this is some thing like cascading prompt.
My doubt is, here NAM Fiscal Calendar , Custom Time Period, weekly , monthly , quarterly are some custom values. they are not present in any table.column in the database.
With the custom LOVs how can we do cascading…
Please explain me how to bring the custom values and implement the cascading in the universe.
The LOVs are used just to pass the values to a prompt, be it custom LOVs or from the database.
You can then associate it with the desired prompt objects created in your universe and do a cascading effect on it
Have you read about cascading prompts in the semantic layer FAQ.
Doing a simulated test in eFashion universe should give you an idea on how it works.
Then try to enhance it to suit your requirement