since ‎28-05-2018
‎10-12-2019
vipuls85671841
Level 1
Re: Scientific Format In Data Warehouse Report
Avatar

vipuls85671841

vipuls85671841
- Adobe Analytics
Hi hyderziaee​. Tried using Report Builder but since I need this MID data correlated with pages and various events as metrics, the limitations with Report Builder do not let me get entire data. Since only Data Warehouse can be used to extract the report is there a way to get MID in the correct (non-scientific) format?

Views

450

Likes

0

Replies

0
Re: Scientific Format In Data Warehouse Report
Avatar

vipuls85671841

vipuls85671841
- Adobe Analytics
hyderziaee​ Yes, the other team is going to use excel too. Can however try using prepend function in Report Builder to see if that works. Thanks much for the help.

Views

446

Likes

0

Replies

0
Re: Scientific Format In Data Warehouse Report
Avatar

vipuls85671841

vipuls85671841
- Adobe Analytics
Yes. Tried that too but it didn't work

Views

447

Likes

0

Replies

0
Re: Scientific Format In Data Warehouse Report
Avatar

vipuls85671841

vipuls85671841
- Adobe Analytics
Hi ishans9314858​. Tried generating the same report in report builder and faced the same issue again. So copying the data in notepad first is the only option?

Views

447

Likes

0

Replies

0
Re: Scientific Format In Data Warehouse Report
Avatar

vipuls85671841

vipuls85671841
- Adobe Analytics
Thanks for your reply. This file has to be automatically consumed by another team which will not be possible with this solution. Is it going to be the same if the file is scheduled through report builder as well? Any other alternatives?

Views

452

Likes

0

Replies

0
Scientific Format In Data Warehouse Report
Avatar

vipuls85671841

vipuls85671841
- Adobe Analytics
Hi. I am trying to schedule a marketing cloud visitor ID report through data warehouse and when I get the excel file the ID is converted into a scientific format. I have tried to change format by using "Custom" format in excel however that results in multiple zeroes after a few digits. Also this report will be consumed as it is so can't really edit it every time before it is used. Any suggestions would be welcome.

Views

2.7K

Likes

0

Replies

12
Likes given to