How to modify msp_web_view_reports table

[Mauricio@BVFG]

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis. Every
Monday I have to run a long change routine unselecting the previous 7 days
(previous to last week) and selecting over the new 7 days for last week. When
done over 15 different views is bothersome to say the less. I found out there
are two fields in the msp_web_view_reports tables which contain the pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the dates for
which the view will run:
.....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
....

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Rod Gill]

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a cube
is built it does so only for the date range you specify in PWA admin. Dates
should automatically move on in time.

 

[Mauricio@BVFG]

Rod,

Thanks for the response. I will follow your advice and will desist modifying
those fields.

On the other hand I have never see a view that swifts time automatically -
Maybe becuse of the way I defined the view. I have the Time and Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field for the
Task Type in the column area, and the Actual work in the detail area. Every
week I have to modify the Time field and, like I said before, unselect the
previous 7 days and select the 7 neww ones (corresponding to the last time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and I can't
find how to make a flexible view time dependant.

THANKS AGAIN!

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a cube
is built it does so only for the date range you specify in PWA admin. Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7 days
(previous to last week) and selecting over the new 7 days for last week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Rod Gill]

In the Admin View that defines the time period for the Cube building (I
forget its name). Typically you might specify previous week and next 3
months or what ever works for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time automatically -
Maybe becuse of the way I defined the view. I have the Time and Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field for
the
Task Type in the column area, and the Actual work in the detail area.
Every
week I have to modify the Time field and, like I said before, unselect the
previous 7 days and select the 7 neww ones (corresponding to the last time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a
cube
is built it does so only for the date range you specify in PWA admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Mauricio@BVFG]

By following your way it will work for the first week because on the second
week I will get a two weeks report comprised by this week and the previous
one. It goes back to the original question: automating Portfolio Views
filtering.

Thanks for your input.

Mauricio

In the Admin View that defines the time period for the Cube building (I
forget its name). Typically you might specify previous week and next 3
months or what ever works for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time automatically -
Maybe becuse of the way I defined the view. I have the Time and Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field for
the
Task Type in the column area, and the Actual work in the detail area.
Every
week I have to modify the Time field and, like I said before, unselect the
previous 7 days and select the 7 neww ones (corresponding to the last time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a
cube
is built it does so only for the date range you specify in PWA admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Mauricio@BVFG]

By following your way it will work for the first week because on the second
week I will get a two weeks report comprised by this week and the previous
one. It goes back to the original question: automating Portfolio Views
filtering.

Thanks for your input.

Mauricio

In the Admin View that defines the time period for the Cube building (I
forget its name). Typically you might specify previous week and next 3
months or what ever works for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time automatically -
Maybe becuse of the way I defined the view. I have the Time and Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field for
the
Task Type in the column area, and the Actual work in the detail area.
Every
week I have to modify the Time field and, like I said before, unselect the
previous 7 days and select the 7 neww ones (corresponding to the last time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

:

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a
cube
is built it does so only for the date range you specify in PWA admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Rod Gill]

So is the cube built using a fixed date range rather than last week/month
and next months?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

On second thoughts, your approach is valid if only I had Weekly reports.
The
fact is I have monthly reports as well.

By following your way it will work for the first week because on the
second
week I will get a two weeks report comprised by this week and the
previous
one. It goes back to the original question: automating Portfolio Views
filtering.

Thanks for your input.

Mauricio

In the Admin View that defines the time period for the Cube building (I
forget its name). Typically you might specify previous week and next 3
months or what ever works for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


message
Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time
automatically -
Maybe becuse of the way I defined the view. I have the Time and
Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field
for
the
Task Type in the column area, and the Actual work in the detail area.
Every
week I have to modify the Time field and, like I said before,
unselect the
previous 7 days and select the 7 neww ones (corresponding to the last
time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and
I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

:

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When
a
cube
is built it does so only for the date range you specify in PWA
admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


message
Hi,

I am managing quite a few Portfolio Analyzer views on a weekly
basis.
Every
Monday I have to run a long change routine unselecting the
previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I
found out
there
are two fields in the msp_web_view_reports tables which contain
the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found
the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several
fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these
can be
managed like I said via SQL job my life will be easy on
Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Mauricio@BVFG]

The cube is built From 4 weeks ago, until 2 weeks into the future. The views
instead are managed using static timeframes, for istance I run the Weekly
time report which shows project data for the last week. There is a similar
view that goes for the full month. Views must be available all the time for
the executives group.

So is the cube built using a fixed date range rather than last week/month
and next months?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

On second thoughts, your approach is valid if only I had Weekly reports.
The
fact is I have monthly reports as well.

By following your way it will work for the first week because on the
second
week I will get a two weeks report comprised by this week and the
previous
one. It goes back to the original question: automating Portfolio Views
filtering.

Thanks for your input.

Mauricio

:

In the Admin View that defines the time period for the Cube building (I
forget its name). Typically you might specify previous week and next 3
months or what ever works for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


message
Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time
automatically -
Maybe becuse of the way I defined the view. I have the Time and
Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field
for
the
Task Type in the column area, and the Actual work in the detail area.
Every
week I have to modify the Time field and, like I said before,
unselect the
previous 7 days and select the 7 neww ones (corresponding to the last
time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and
I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

:

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When
a
cube
is built it does so only for the date range you specify in PWA
admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


message
Hi,

I am managing quite a few Portfolio Analyzer views on a weekly
basis.
Every
Monday I have to run a long change routine unselecting the
previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I
found out
there
are two fields in the msp_web_view_reports tables which contain
the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found
the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several
fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these
can be
managed like I said via SQL job my life will be easy on
Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Rod Gill]

So why use static timeframes for the Views? What happens when you don't
apply static dates?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

The cube is built From 4 weeks ago, until 2 weeks into the future. The
views
instead are managed using static timeframes, for istance I run the Weekly
time report which shows project data for the last week. There is a similar
view that goes for the full month. Views must be available all the time
for
the executives group.

So is the cube built using a fixed date range rather than last week/month
and next months?

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

On second thoughts, your approach is valid if only I had Weekly
reports.
The
fact is I have monthly reports as well.

:

By following your way it will work for the first week because on the
second
week I will get a two weeks report comprised by this week and the
previous
one. It goes back to the original question: automating Portfolio Views
filtering.

Thanks for your input.

Mauricio

:

In the Admin View that defines the time period for the Cube building
(I
forget its name). Typically you might specify previous week and next
3
months or what ever works for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


message
Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time
automatically -
Maybe becuse of the way I defined the view. I have the Time and
Resource
Status dimensions as Filters, the RBS in the Row area, a Custom
Field
for
the
Task Type in the column area, and the Actual work in the detail
area.
Every
week I have to modify the Time field and, like I said before,
unselect the
previous 7 days and select the 7 neww ones (corresponding to the
last
time
period)

Where can I see some examples for automatic time shifting views? I
am
following Gary & Dale's Orange and Blue books and other resources
and
I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

:

Hi,

Firstly editing anything in the files you mention could corrupt
your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views?
When
a
cube
is built it does so only for the date range you specify in PWA
admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and
more


message
Hi,

I am managing quite a few Portfolio Analyzer views on a weekly
basis.
Every
Monday I have to run a long change routine unselecting the
previous 7
days
(previous to last week) and selecting over the new 7 days for
last
week.
When
done over 15 different views is bothersome to say the less. I
found out
there
are two fields in the msp_web_view_reports tables which contain
the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found
the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains
several
fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these
can be
managed like I said via SQL job my life will be easy on
Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Gary L. Chefetz [MVP]]

Mauricio:

Unfortunately, filtering doesn't support the concept of "this week" or "next
week." You might be able to change the view definitions programmatically to
accomplish this once a week.

Rod,

Thanks for the response. I will follow your advice and will desist
modifying
those fields.

On the other hand I have never see a view that swifts time automatically -
Maybe becuse of the way I defined the view. I have the Time and Resource
Status dimensions as Filters, the RBS in the Row area, a Custom Field for
the
Task Type in the column area, and the Actual work in the detail area.
Every
week I have to modify the Time field and, like I said before, unselect the
previous 7 days and select the 7 neww ones (corresponding to the last time
period)

Where can I see some examples for automatic time shifting views? I am
following Gary & Dale's Orange and Blue books and other resources and I
can't
find how to make a flexible view time dependant.

THANKS AGAIN!

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a
cube
is built it does so only for the date range you specify in PWA admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Lars Hammarberg]

When you're modifying the views, the resulting XML used by the OWC pivot
component is stored in the field you've described.
Modifying these entries will not compromise your plans in the least - all
that's going to be corrupted if you make some mistakes are the portfolio
views - and those are easily re-built.
The only thing barring you from a simple query is the fact that the field is
of type Text, which will require the use of pointers - but once over that
tsql hurdle, there's nothing to stop you from creating dynamic one-week
views from data at hand.

You could even execute the modifications code with a trigger on the table
holding status for the cube building process...

I've got a script modifying these entries somewhere that I use when I have
to use another Analysis Services server and the customer have LOTS of views
with the XML pointing to a now obsolete server.

/Lars Hammarberg
www.camako.se

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7 days
(previous to last week) and selecting over the new 7 days for last week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Mauricio@BVFG]

Lars,

Thank you very much for your answer. We are indeed looking on how to upload
the OWC xml file.

Mauricio

When you're modifying the views, the resulting XML used by the OWC pivot
component is stored in the field you've described.
Modifying these entries will not compromise your plans in the least - all
that's going to be corrupted if you make some mistakes are the portfolio
views - and those are easily re-built.
The only thing barring you from a simple query is the fact that the field is
of type Text, which will require the use of pointers - but once over that
tsql hurdle, there's nothing to stop you from creating dynamic one-week
views from data at hand.

You could even execute the modifications code with a trigger on the table
holding status for the cube building process...

I've got a script modifying these entries somewhere that I use when I have
to use another Analysis Services server and the customer have LOTS of views
with the XML pointing to a now obsolete server.

/Lars Hammarberg
www.camako.se

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7 days
(previous to last week) and selecting over the new 7 days for last week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Mauricio@BVFG]

When you're modifying the views, the resulting XML used by the OWC pivot
component is stored in the field you've described.
Modifying these entries will not compromise your plans in the least - all
that's going to be corrupted if you make some mistakes are the portfolio
views - and those are easily re-built.
The only thing barring you from a simple query is the fact that the field is
of type Text, which will require the use of pointers - but once over that
tsql hurdle, there's nothing to stop you from creating dynamic one-week
views from data at hand.

You could even execute the modifications code with a trigger on the table
holding status for the cube building process...

I've got a script modifying these entries somewhere that I use when I have
to use another Analysis Services server and the customer have LOTS of views
with the XML pointing to a now obsolete server.

/Lars Hammarberg
www.camako.se

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7 days
(previous to last week) and selecting over the new 7 days for last week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Mauricio@BVFG]

Rod,

No corruption whatsoever can happen from modifiying a Text field in a view
table. The most that can happen is that the XML file is not well formed then
not understood correctly by the browser.

Thanks

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a cube
is built it does so only for the date range you specify in PWA admin. Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7 days
(previous to last week) and selecting over the new 7 days for last week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP

 

[Rod Gill]

He mentioned other tables than the MSP_VIEW ones, which can cause
corruptions if edited. But you're right, changing MSP_VIEW tables alone is
safe as anything you edit simply gets over-written next time the project is
published.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more
Project VBA Book now in stock: visit www.projectvbabook.com

Rod,

No corruption whatsoever can happen from modifiying a Text field in a view
table. The most that can happen is that the XML file is not well formed
then
not understood correctly by the browser.

Thanks

Hi,

Firstly editing anything in the files you mention could corrupt your
projects, it's not recommended.

Secondly, I don't understand why you need to change the views? When a
cube
is built it does so only for the date range you specify in PWA admin.
Dates
should automatically move on in time.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Hi,

I am managing quite a few Portfolio Analyzer views on a weekly basis.
Every
Monday I have to run a long change routine unselecting the previous 7
days
(previous to last week) and selecting over the new 7 days for last
week.
When
done over 15 different views is bothersome to say the less. I found out
there
are two fields in the msp_web_view_reports tables which contain the
pivot
table and chart information for each view. For instance, the
WVIEW_OWC_PIVOT_XML field contains an XML file in which I found the
dates
for
which the view will run:
....
<x:IncludedMember>
<x:Name>7</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[14]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>6</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[13]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>5</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[12]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>4</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[11]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>3</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[10]</x:UniqueName>

</x:IncludedMember>
<x:IncludedMember>
<x:Name>2</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[9]</x:UniqueName>
</x:IncludedMember>
<x:IncludedMember>
<x:Name>1</x:Name>
<x:UniqueName>[Time].[All
Years].[2006].[Q4].[October].[8]</x:UniqueName>
</x:IncludedMember>
...

On the other hand the WVIEW_OWC_PIVOT_XML field contains several fields
I
would like also to modify via SQL job, like

<x:Caption>
<xataSourceIndex>-1</xataSourceIndex>
<xata>"IT Time Report - September 24 to 30, 2006"</xata>
</x:Caption>


Has someone out there played around with these fields? If these can be
managed like I said via SQL job my life will be easy on Mondays!!!!

Thanks beforehand!

Mauricio Iannini, PMP