Yes you are correct in that in using the demo-db.
But the customer db shows the exakt pattern.
So that's why I need to see if there is a way to change string.
I have tried the substring command but it's a no go.
Meanwhile I will try to find that Netapp report that you talk about.
Duke Systems AB
08 765 48 80
070 886 18 55
20 okt 2013 kl. 23:23 skrev "ostiguy" <firstname.lastname@example.org<mailto:email@example.com>>:
Re: datawarehouse string functions
created by ostiguy<https://communities.netapp.com/people/ostiguy> in OnCommand Insight - View the full discussion<https://communities.netapp.com/message/118855#118855>
There probably is, but before we go down that road...
Are you playing with the OCI demo database (the hostname "beet" seems suspiciously familiar)? That is a sales tool, and not a training tool. Attempting to build custom reports off of it may be hazardous to your sanity as the data may not be realistic.
What you seem to be seeing is an internal volume name (flexvol in Ontap-speak), and not a storage pool name (aggregate in Ontap-speak), but this might be due to manually created data in the demo db.
That all said, if you are convinced you'd need to do a similar string function, we can take a look tomorrow. I know you could do this with SQL if you were building a SQL based report, but I am not enough of a Cognos guy to be able to swear this could be done in Cognos, although I strongly suspect it could be (I know we have a "NetApp vendor centric report" kicking around we have created that breaks apart HA pairs into individual controllers to report at that level for shops coming to OCI from DFM / Ops Manager that had a similar methodology - in this report we are doing some string magic to crack apart HA pair array names, etc.
Reply to this message by replying to this email -or- go to the message on NetApp Community<https://communities.netapp.com/message/118855#118855>
Start a new discussion in OnCommand Insight by email<mailto:firstname.lastname@example.org> or at NetApp Community<https://communities.netapp.com/choose-container.jspa?contentType=1&containerType=14&container=3203>