Hi Azhagumuthu,
To explain my request, I'm talking about Hierarchical prompt in Cognos reports, like this :

Which we can use only if source package for the report has this kind of DMR objects :

My request is : could it be possible to have an equivalent (custom ?) prompt with relational objects in package :

------------------------------
Pierre-Frank MOUZON
------------------------------
Original Message:
Sent: Wed November 05, 2025 04:15 PM
From: Azhagumuthu S
Subject: Custom Relational Tree Prompt
Hi Pierre-Frank MOUZON,
That phrase could mean a few different things depending on your context.
For example
If you're referring to Python or R packages:
- Are you talking about a decision tree or tree based model.
- And by "relational package," do you mean a relational database interface Ie., using tree prompts or build from relational data
2If you mean prompt engineering or LLM use:
- Are you describing a structured prompt that represents hierarchical relationships.
- "And is relational package " referring to something LangChain , LlamaIndex or a similar framework.
What language/environment you're using and what you mean by" custom tree point prompt"
------------------------------
Azhagumuthu S
Senior Analyst
HCL TECH
Navalur
8489641758
Original Message:
Sent: Wed November 05, 2025 11:38 AM
From: Pierre-Frank MOUZON
Subject: Custom Relational Tree Prompt
Tree prompts are very useful in Cognos report prompt page, but it needs dmr packages to works.
Problem with dmr packages is that report performance is awful when source database tables contain millions of lines.
Does someone know if a custom tree prompt based on relational package exists ?
------------------------------
Pierre-Frank MOUZON
------------------------------