Community

Subscribe
Highlighted

datawarehouse string functions

Hi .

Im having a problem that im not serten how to solve.

in the volue capacity datamart there is an object called "storage pool" that gives me what i want( and more).

this field gives me a storage pool that is connected to a specific host.

but it gives me more the i need, for instance i ad host field and storage pool i get:

Host          storage pool

BEET        AGGREGATE:NtapiSCSI1:vol0

but im only intrested in the par between the ':' or NtapiSCSI1.

is there a way to solve that?

Regards

Jonas


                

Re: datawarehouse string functions

Hey Jonas,

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.

Re: datawarehouse string functions

Hi.

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.

Mvh

Jonas Enhörning

Duke Systems AB

08 765 48 80

070 886 18 55

20 okt 2013 kl. 23:23 skrev "ostiguy" <xdl-communities@communities.netapp.com<mailto:xdl-communities@communities.netapp.com>>:

<https://communities.netapp.com/index.jspa>

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>

Hey Jonas,

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:discussions-community-products_and_solutions-storage_management_software-oncommand--insight@communities.netapp.com> or at NetApp Community<https://communities.netapp.com/choose-container.jspa?contentType=1&containerType=14&container=3203>

Re: datawarehouse string functions

Hey Jonas,

I tentatively think you'd need to write your report in SQL in Report Studio to do this - I poked around in Cognos, and I don't think the Cognos layer string manipulation functions are robust enough to do this. I will confirm when my pre-sales reporting specialists are back in the office tomorrow