TM1 Forum

Hi,

When we select items in dimension title to export in excel snapshot ,we got the option
choose dimension title to export, if we tick that option.

Then, after export two sheets generated for each title element.

For example:
select title dimension( 2 items):
Product
ProductA

when export two sheets generated for each element
sheet 1 sheet1_Product ProductA ProductA1

Kindly suggest the way that we can export only one sheet for each item

bsjain wrote:if we tick that option.

Simple enough, don't tick that option. You are telling TM1 to cycle through the Product dimension and create a tab for each product.

Hi,

I agree with your point, but I cant understand why two similar sheets created for each element.

bsjain wrote:Hi,

I agree with your point, but I cant understand why two similar sheets created for each element.

You should get one sheet for every element in the current subset. A subset can contain the same element more than once in which case you'd get multiple tabs for that element. Is that what's happening?