You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add sequence number & date in BI excel template

Received Response
199
Views
2
Comments
edited Sep 20, 2023 5:43PM in Reporting and Analytics for ERP 2 comments

Hi,

I have developed a Data model and attached an Excel template in BI. I am able to generate the data as expected. However; we have a requirement to add a sequence number column in the output (excel format). Is there any syntax to add sequence number column directly in the excel template without adding rownum in the DM as my DM model having many columns in the sub query (eg. select * from (select col1,col2, col3, etc..). Hence I am looking for a way to add the excel template itself.

Also, how can i add the report run date in the excel template.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!