SAC - scripting in Story - changing drill limitation for table by script?

[igdulia]

Hi all,

Do we have an option to change drilling limitation to unlimited via script in SAC Optimaze View Mode Story?

The idea is to use it for the export table to exel with one click (because otherwise users need to remember to change the limit and only then click the export to exel)

So it will be like:

Table_1...... ; //Is it possible just to change drill limitation to unlimited?
ExportToExcel_1.exportReport();

Thanks.

[N1kh1l · Accepted solution]

igdulia

igduliaJust see if the below will API for datasource work

setHierarchyLevel(dimension: string | DimensionInfo JSON, level?: integer): void

Sets the hierarchy level of the dimension. If the dimension or the hierarchy level of the dimension is invalid, then this operation is ignored. The default value of the level is defined by the dimension's default level. For data sources associated with charts, the level value is optional.

Br.

Nikhil

[igdulia · Accepted solution]

Looks like I was not cleare.

I need to chnage the number of records in the table, to unlimited using script.